Database

This skill provides comprehensive guidance for designing PostgreSQL database schemas. It covers data type selection, indexing strategies, partitioning approaches, constraints, and performance patterns for various workload types including insert-heavy, update-heavy, and upsert scenarios.

A comprehensive reference guide for database migrations across popular ORMs including Sequelize, TypeORM, and Prisma. It covers schema transformations, data migrations, rollback strategies, and zero-downtime deployment patterns with practical code examples.

A comprehensive reference guide for SQL query optimization that covers EXPLAIN plan analysis, indexing strategies, pagination optimization, and common performance anti-patterns. The skill provides practical SQL examples for PostgreSQL and MySQL to help developers identify and fix slow queries.

A comprehensive reference guide for working with Supabase databases. Provides documentation on authentication flows (signup, signin, OAuth), Row Level Security policy patterns, table relationships and foreign keys, and query patterns including filtering, pagination, and performance optimization.

This skill provides comprehensive MongoDB best practices and reference documentation. It covers schema design patterns (embedding vs referencing), index strategies (ESR rule), aggregation pipeline optimization, and connection best practices. The associated MCP operates in read-only mode with no write capabilities.