Database Management Agent Skills

Database Migration & Schema Evolution

Executes seamless database schema and data migrations across multiple ORMs with robust rollback and zero-downtime deployment strategies.

Data Warehouse & dbt Modeling

Designs and builds maintainable data warehouses using dbt and Kimball-style dimensional modeling principles.

Prisma Expert

Architects and optimizes database schemas, migrations, and queries using the Prisma ORM.

CQRS Architectural Design

Implement Command Query Responsibility Segregation to optimize read and write operations in high-scale systems.

Supabase Database Expert

Architects, queries, and manages production-grade Supabase environments with PostgreSQL, Row Level Security, and Edge Functions.

Blacklake OpenAPI Database Query

Queries and manages integrated connectors and API configurations within the v3_openapi database using structured SQL templates.

Database Tenant & Org Manager

Queries and manages tenant, organization, and factory information within the v3_user database using structured SQL execution.

Data Lake Architect

Designs scalable data lake and lakehouse architectures using optimized partitioning, storage tiers, and high-performance formats like Iceberg and Parquet.

dbt Transformation Patterns

Implements production-ready dbt patterns for scalable data modeling and analytics engineering.

SQLModel Task Data Modeling

Architects robust, type-safe, and asynchronous database schemas for task-based applications using SQLModel and PostgreSQL.

SQL Performance Optimizer

Optimizes SQL query performance by applying proven patterns for indexing, JOIN structures, and execution plan analysis.

CQRS Projection Patterns

Builds efficient read models and materialized views from event streams using CQRS and event sourcing patterns.

SQL Optimization Patterns

Optimizes database performance through advanced indexing, query plan analysis, and efficient query architectural patterns.

Database Migration

Manage database schema and data migrations across ORMs with zero-downtime strategies and rollback procedures.

Database Migration & Schema Management

Executes seamless database migrations, schema transformations, and zero-downtime deployment strategies across multiple ORMs and platforms.

SQL Optimization Patterns

Optimizes database performance through advanced indexing strategies, query plan analysis, and efficient SQL implementation patterns.

Supabase Database

Streamlines Supabase database management including complex queries, CRUD actions, and Row Level Security implementation.

Data Quality Frameworks

Implements production-grade data validation and observability using Great Expectations, dbt tests, and formal data contracts.

PostgreSQL Table Design

Architects optimized, production-grade PostgreSQL schemas using industry-standard best practices and performance patterns.

Cloudflare R2 & D1 Storage Mastery

Optimizes development with Cloudflare's edge storage products including R2 object storage, D1 SQL databases, and KV namespaces through battle-tested patterns.

PostgreSQL MCP Analyst

Analyzes PostgreSQL databases through schema discovery and read-only SQL queries to generate actionable data insights.

Firebase Firestore Specialist

Optimizes Firebase Firestore implementations with expert guidance on NoSQL patterns, real-time synchronization, and robust security rules.

Firebase Firestore Specialist

Architects and implements scalable NoSQL database solutions using Firebase Firestore with real-time sync and offline-first capabilities.

Database Administrator

Manages database operations, performance tuning, backup/recovery, and security through structured guidance and implementation patterns.

Solomon Database Consultant

Performs expert-level database schema analysis, query optimization assessments, and architectural reviews to ensure data integrity and performance.

Database Design & Optimization

Designs high-performance database schemas and manages migrations for PostgreSQL, MySQL, and NoSQL systems.

Firebase Firestore Specialist

Architects high-performance NoSQL databases and manages real-time synchronization for mobile-first Firestore applications.

SQLite & Drizzle Database Management

Implements type-safe SQLite database workflows using LibSQL and Drizzle ORM for local, Turso, and Cloudflare D1 environments.

SQLModel Task & User Schemas

Generates robust, type-safe SQLModel database schemas optimized for PostgreSQL performance and Better Auth integration.

Ghost CMS Database Migration

Automates the creation, implementation, and testing of database schema migrations for Ghost CMS.