Database Management Agent Skills

Supabase Query Optimizer

Optimizes Supabase PostgreSQL database performance by analyzing execution plans and implementing advanced indexing and RLS strategies.

Database Migration & Schema Management

Automates and guides complex database migrations across multiple ORMs with a focus on zero-downtime and data integrity.

PostgreSQL Table Design

Architects high-performance PostgreSQL schemas using industry-standard best practices for data integrity and scalability.

PostgreSQL Table Design

Designs optimized PostgreSQL schemas using industry best practices for performance, data integrity, and scalability.

SQL Optimization Patterns

Optimizes SQL queries and database schemas using advanced indexing, execution plan analysis, and performance patterns.

Database Migration & Schema Management

Executes seamless database migrations across multiple ORMs and platforms using zero-downtime strategies and robust rollback procedures.

SQL Optimization Patterns

Optimizes database performance through advanced SQL query analysis, strategic indexing, and efficient execution patterns.

Database Migration & Schema Management

Execute database migrations across multiple ORMs and platforms using zero-downtime strategies and robust rollback procedures.

PostgreSQL Database Manager

Manages PostgreSQL database connections and executes secure SQL queries with automated schema introspection and result formatting.

Elasticsearch & OpenSearch

Integrates Elasticsearch and OpenSearch for complex search queries, data aggregations, and comprehensive index management.

PostgreSQL Table Design Expert

Architects high-performance PostgreSQL schemas using industry-standard best practices for indexing, data types, and normalization.

Database Migration

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

PostgreSQL Table Design

Architects optimized PostgreSQL schemas using industry-standard best practices for data integrity and high-performance indexing.

PostGIS Geospatial Development

Implements best practices for querying and managing geospatial data in PostgreSQL with PostGIS.

Supabase Database Design

Enforces lean PostgreSQL conventions and a tight-fit design philosophy for optimized Supabase database schemas.

Supabase Project Bootstrapper

Bootstraps new Supabase projects with professional tooling for task management, SQL formatting, and schema introspection.

DB Schema Designer

Designs scalable, optimized database schemas and generates production-ready migrations across SQL and NoSQL platforms.

InstantDB

Provides expert guidance and best practices for building, debugging, and querying with the InstantDB real-time database.

Understanding Data

Performs systematic data profiling and exploratory analysis to reveal the structure, quality, and relationships within relational databases.

BigQuery ETL Core

Establishes foundational project structures, naming conventions, and privacy standards for managing large-scale BigQuery ETL workflows.

Query Writer

Generates and maintains standardized BigQuery SQL and Python ETL scripts following Mozilla's data engineering conventions and partitioning patterns.

Backend Models

Defines and structures database schemas, entities, and relationships while ensuring data integrity and performance through constraints and indexing.

Database Migration & ORM Tools

Executes and manages database schema migrations, data transformations, and rollback procedures across multiple ORMs and platforms.

SQL Optimization Patterns

Optimizes SQL queries and database schemas using advanced indexing, EXPLAIN analysis, and performance-tuning patterns.

SQL Optimization Patterns

Optimizes SQL query performance through systematic execution plan analysis, advanced indexing strategies, and proven query restructuring patterns.

PostgreSQL Table Design

Architects production-grade PostgreSQL schemas using expert-level best practices for data integrity, performance, and scalability.

Query Performance Analysis

Analyzes database query performance, detects N+1 issues, identifies missing indexes, and guides safe index migrations.

Supabase Expert

Manages Supabase database operations, security policies, and edge functions following project-specific standards and real-time state verification.

SQLAlchemy Conversion

Converts asyncpg database code to SQLAlchemy 2.0+ asynchronous patterns while preserving performance and transaction integrity.

AsyncPG Database Detection

Scans Python and FastAPI projects to identify asyncpg imports, connection patterns, and query logic for migration to SQLAlchemy.