Database Management Agent Skills

PostGIS Spatial Database

Enforces PostGIS 3.6.1 best practices for managing complex geographic data, spatial queries, and advanced geometry operations.

Typedown Expert

Transforms unstructured Markdown documentation into rigorous, machine-verifiable data schemas using Pydantic models and YAML entities.

Doctrine Elegant Entity Generator

Generates Doctrine entities and repositories following Elegant Objects principles for robust, maintainable PHP code.

Smoke Test Database

Validates database connectivity, performance SLAs, schema integrity, and backup readiness during software release workflows.

PostgreSQL Patterns & Optimization

Optimizes PostgreSQL database performance and security through standardized schema design, indexing strategies, and advanced query patterns.

Snowflake Semantic View Manager

Automates the creation, validation, and management of Snowflake semantic views and semantic layer definitions using the Snowflake CLI.

TimescaleDB Time-Series Optimization

Optimizes time-series data management by enforcing TimescaleDB 2.24.0 best practices for hypertables, continuous aggregates, and compression.

PostgreSQL Development Patterns

Enforces transaction safety, strict typing, and naming conventions for PostgreSQL to prevent data corruption and runtime errors.

ActiveRecord

Streamlines Ruby on Rails database management with expert patterns for migrations, associations, and query optimization.

PostgreSQL 18 Architecture

Enforces PostgreSQL 18 best practices for schema design, migrations, and high-performance database architecture.

Database Management & Schema Optimization

Manages database schemas, migrations, and performance optimizations using Drizzle ORM and Neon Postgres.

Supabase RLS Fixer

Resolves Supabase Row Level Security issues and manages user context for background jobs and system processes.

Database Design Patterns

Optimizes database architectures through expert schema design, query tuning, and scalable persistence patterns for SQL and NoSQL environments.

Database Patterns & Schema Design

Implement production-grade database architectures, optimized queries, and robust migration strategies using modern ORMs and SQL best practices.

Supabase Local Development

Streamlines the setup and management of local Supabase environments for faster, offline-ready full-stack development.

Supabase Realtime

Enable real-time data synchronization and event listening for Supabase applications directly within your development environment.

SQLite Operations

Implements robust SQLite database patterns for Python projects, including state management, async operations, and high-performance configurations.

SQL Design Patterns

Provides a comprehensive reference for advanced SQL syntax, optimization strategies, and common query implementation patterns.

DynamoDB Access Pattern Expert

Streamlines DynamoDB single-table design by interactively eliciting, formalizing, and documenting application access patterns.

DynamoDB Query Interface Generator

Generates language-agnostic repository interfaces and data access layer skeletons from DynamoDB table designs.

Kysely Query Converter

Transforms raw SQL queries into type-safe Kysely TypeScript code for streamlined database management.

DynamoDB Table Designer

Designs optimized DynamoDB single-table structures by mapping complex access patterns to efficient primary keys, GSIs, and query operations.

DynamoDB Single-Table Designer

Orchestrates the end-to-end design process for DynamoDB single-table architectures by managing access patterns, key schemas, and query interfaces.

Atlan SQL Connector Patterns

Guides the development of Atlan SQL metadata and query extraction connectors by selecting and implementing standardized SDK patterns.

AI Data Modeler

Generates comprehensive entity model documentation featuring Mermaid.js ER diagrams and standardized attribute tables.

Database Migrations

Manages SQLite schema evolutions using disciplined, reversible migration patterns and TypeScript-based runners.

ClickHouse Query Analyzer

Analyzes and optimizes ClickHouse database queries to improve performance, reduce resource consumption, and resolve execution bottlenecks.

SQL Quality Optimizer

Optimizes MySQL query performance by automatically refactoring inefficient SQL patterns and validating index impact through iterative measurement.

Litestream for SQLite

Manages SQLite disaster recovery and real-time streaming replication to cloud storage backends.

AI Agent Retrieval Policy

Optimizes agent memory queries through intelligent intent classification, tiered search routing, and automated fallback chains.