Data access patterns, GUID primary keys, JSON configuration, entity configuration, and transaction handling for PostgreSQL. Use this skill when working with Entity Framework Core and database operations.
Prisma schema design and database operations for IntelliFill. Use when modifying database schema, writing queries, or managing migrations.
Data warehouse design mastery with star schema, dimensional modeling, fact/dimension tables, slowly changing dimensions, and enterprise best practices. Complete schema examples included.
Database specialist - handles RLS policies, migrations, type generation, and Supabase integration patterns.
High-performance CLI for working with SQL dump files: split/merge by table, analyze contents, validate integrity, convert between MySQL/PostgreSQL/SQLite/MSSQL, create FK-safe samples, shard multi-tenant dumps, generate ERD diagrams, reorder for safe imports, and run SQL analytics with embedded DuckDB. Use when working with .sql dump files for migrations, dev seeding, CI validation, schema visualization, data extraction, or ad-hoc analytics.
Analyze and optimize database schemas and relationships
Manage PostgreSQL databases using Postgres MCP. Query data, inspect schemas, analyze table structures, run migrations, debug database issues, and manage test data. Use when working with databases, debugging queries, or validating data integrity.
Expert at Neon PostgreSQL database operations, migrations, schema validation, and query optimization. Use when working with database schemas, migrations, SQL queries, Neon connections, or diagnosing database issues.
Analyze and optimize database schemas, identify performance issues, and suggest improvements. Use when working with database structure, indexes, or query performance.
PostgreSQL DBA skill for schema design review, indexing, query tuning (EXPLAIN/ANALYZE), vacuum/autovacuum, concurrency/locking, partitioning, backup/restore, replication/HA, and safe migrations. Use for tasks like diagnosing slow queries, designing indexes and constraints, and operating Postgres in production.
Performance and design guidelines for PostgreSQL database in RSSVibe, including connection pooling, JSONB columns, and query optimization. Use this skill when optimizing database performance.
Production-grade database design skill for SQL/NoSQL selection, schema design, indexing, and query optimization
Expert PostgreSQL database guidance using Bun.sql client. Provides comprehensive patterns for queries, schema design, JSON/JSONB operations, full-text search, indexing, PL/pgSQL, pgvector, and performance optimization. Use when working with PostgreSQL databases, writing SQL queries, optimizing performance, designing schemas, or implementing database features. Complements bun-expert skill for Bun.sql integration.
Foundational SQL patterns for query writing, schema design, and dialect differences. Use when writing SQL queries, designing database schemas, understanding SQL syntax across PostgreSQL/MySQL/SQLite, or preparing SQL for conversion to other query languages. This is a meta-skill for SQL derivatives.
Database integration - schema design, queries, migrations, optimization
Scale PostgreSQL - partitioning, connection pooling, high availability
ALWAYS use this skill when users ask to create, generate, or write UNIT TESTS for BigQuery SQL queries. Invoke proactively whenever the request includes "test" or "tests" with a query/table name. This skill is for unit testing ONLY (not data quality checks - use bigconfig-generator for Bigeye monitoring). Works with bigquery-etl-core skill to understand query patterns.
Use this skill when writing or updating SQL queries (query.sql) or Python ETL scripts (query.py) following Mozilla BigQuery ETL conventions. ALWAYS checks for and updates existing tests when modifying queries. Coordinates downstream updates to schemas and tests. Works with bigquery-etl-core, metadata-manager, and sql-test-generator skills.
PostgreSQL database optimization combining institutional knowledge with live analysis
Write secure, performant database queries following best practices for data retrieval and manipulation. Use this skill when writing SQL queries, ORM query methods, or database query builders. Use this skill when fetching data with joins, filters, or complex query conditions. Use this skill when implementing eager loading to prevent N+1 query problems. Use this skill when optimizing query performance with proper indexing strategies. Use this skill when writing parameterized queries to prevent SQL injection. Use this skill when implementing database transactions for related operations. Use this skill when working with query optimization, caching strategies, or query timeout handling.
Expert-level dbt (data build tool), models, tests, documentation, incremental models, macros, and Jinja templating
DynamoDB single-table design using dynamodb-toolbox v2. Use when creating entities, defining key patterns, designing GSIs, writing queries, implementing pagination, or working with any DynamoDB data layer in TypeScript projects.
Complete guide to ActiveRecord query optimization, associations, scopes, and PostgreSQL-specific patterns. Use this skill when writing database queries, designing model associations, creating migrations, optimizing query performance, or debugging N+1 queries and grouping errors. Trigger keywords: database, models, associations, validations, queries, ActiveRecord, scopes, migrations, N+1, PostgreSQL, indexes, eager loading
