Database Management Agent Skills

Database Management & Schema Optimization

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

SQL Optimization Patterns

Optimizes database performance through indexing strategies, EXPLAIN plan analysis, and query refactoring.

Database Design Patterns

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

PostgreSQL Schema Architect

Designs high-performance, normalized PostgreSQL schemas using industry best practices for indexing, data types, and scaling.

Database Migration & Schema Evolution

Automates complex database schema migrations, ORM transitions, and zero-downtime data transformations using AI-guided best practices.

Supabase Local Development

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

AWS DynamoDB Architect

Optimizes Amazon DynamoDB data modeling, single-table design, and Terraform implementation with high-performance access patterns.

Supabase RLS Fixer

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

Database Patterns & Schema Design

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

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.

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.

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.

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.

ClickHouse Query Analyzer

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

Kysely SQL Converter

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

Atlan SQL Connector Patterns

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

AI Agent Retrieval Policy

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

BM25 Keyword Search

Enables high-speed, exact-match keyword searching within the agent-memory system using BM25 scoring.

Neo4j Graph Developer

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

BM25 Keyword Search

Enables fast, precise full-text keyword search and indexing for agent-memory systems using BM25 scoring.

Agent Memory Vector Search

Enables semantic similarity and hybrid keyword-vector search capabilities within the Agent Memory system.

GreyCat

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