Database Management Agent Skills

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.

Snowflake Semantic View Manager

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

PostgreSQL Patterns & Optimization

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

TimescaleDB Time-Series Optimization

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

ActiveRecord

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

PostgreSQL Development Patterns

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

PostgreSQL 18 Architecture

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

C# Database Access Patterns

Streamlines RDBMS integration in C# for PostgreSQL, MySQL, DuckDB, and legacy systems using optimized access patterns and drivers.

Database Management & Schema Optimization

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

Database Design Patterns

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

Supabase Local Development

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

Supabase RLS Fixer

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

Supabase Realtime

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

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.

SQL Design Patterns

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

SQLite Operations

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

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.

Kysely SQL Converter

Converts raw SQL queries into type-safe Kysely TypeScript code to streamline database layer development.

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.

Atlan SQL Connector Patterns

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

GreyCat

Streamlines development in the GreyCat ecosystem with a unified programming language and temporal-graph-vector database for large-scale digital twins.

Neo4j Graph Developer

Streamlines Neo4j development by providing automated data modeling, Cypher query optimization, and schema visualization tools.