python-database-ops
SQLAlchemy and database patterns for Python. Triggers on: sqlalchemy, database, orm, migration, alembic, async database, connection pool, repository pattern, unit of work.
drizzle-orm
Type-safe SQL ORM for TypeScript with zero runtime overhead
postgresql-table-design
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
postgres-patterns
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.
postgres-ops
PostgreSQL operations, optimization, and administration. Use for: schema design, index selection, query tuning with EXPLAIN ANALYZE, postgresql.conf configuration, backup and restore (pg_dump, pg_basebackup, WAL, PITR), vacuum and autovacuum tuning, connection pooling (pgBouncer, pgPool), replication (streaming, logical), partitioning, monitoring (pg_stat_statements, pg_stat_activity), JSONB operations, full-text search (tsvector, tsquery), row-level security (RLS), extensions (PostGIS, pg_trgm, timescaledb), GiST/GIN/BRIN indexes, materialized views, foreign data wrappers, LISTEN/NOTIFY.
postgresql
Query and inspect PostgreSQL schemas, tables, types, and data in the local development database. Use this skill whenever the user asks about the database schema, wants to inspect a table or type, needs to run a query, or asks anything involving PostgreSQL, psql, or the dev database. Trigger on phrases like "what columns does X have", "check the schema", "look at the type", "query the db", "what does the X table look like", or any time understanding the data model would help answer the question.
ss14-databases
SS14 Database System Guide (PostgreSQL and SQLite)
migrate-db
Create database migration files for all three databases (MySQL, MSSQL, PostgreSQL) when schema changes are needed
ss14-migrations
Guide to Creating and Managing Database Migrations in SS14 (PostgreSQL and SQLite)
add-entity
Add a new database entity with migrations for all three databases (MySQL, MSSQL, PostgreSQL)
db-explorer
Connect to PostgreSQL, MySQL, or SQLite databases to explore schema structure, table relationships, and generate ERD diagrams. Use when the user asks to explore a database, document schema, or understand table relationships.
database-designer
Comprehensive database design tool creating complete schemas with tables, fields, indexes, and ER diagrams. Use when users request database design for any system. Generates Markdown docs, SQL scripts, and DrawDB-compatible JSON/DBML files. Supports MySQL, PostgreSQL, SQL Server. Triggers: database design, schema, ER diagram, SQL, data model. | 全面的数据库设计工具，创建完整的数据库架构。触发词：数据库设计、数据库架构、ER图、SQL、数据模型、表设计。
moai-domain-database
Database specialist covering PostgreSQL, MongoDB, Redis, and advanced data patterns for modern applications
sap-sqlscript
This skill should be used when the user asks to "write a SQLScript procedure", "create HANA stored procedure", "implement AMDP method", "optimize SQLScript performance", "handle SQLScript exceptions", "debug HANA procedure", "create table function", or mentions SQLScript, SAP HANA procedures, AMDP, EXIT HANDLER, or code-to-data paradigm. Comprehensive SQLScript development guidance for SAP HANA database programming including syntax patterns, built-in functions, exception handling, performance optimization, cursor management, and ABAP Managed Database Procedure (AMDP) integration.
moai-platform-supabase
Supabase specialist covering PostgreSQL 16, pgvector, RLS, real-time subscriptions, and Edge Functions. Use when building full-stack apps with Supabase backend.
migrate-api-to-tanstack-query
Migrate the current REST API usage to TanStack Query with server-state caching, invalidation, and progressive rollout.
fake-database-setup
Guide for setting up a fake/demo SQLite database with sample data for testing the Night Routine application and taking screenshots. Use this skill when you need to create test data, set up a demo database, take screenshots of the UI, or verify the application with sample assignments and calendar data.
database-design-patterns
Database schema design patterns and optimization strategies for relational and NoSQL databases. Use when designing database schemas, optimizing query performance, or implementing data persistence layers at scale.
salvo-caching
Implement caching strategies for improved performance. Use for reducing database load and speeding up responses.
update-vale-rules
Run Vale RedHat rules against PR/MR changed files only, analyze output for false positives with 90%+ certainty, and create a PR to update vale-at-red-hat rules. Use this skill when asked to improve Vale rules, find false positives in a PR, or update the Vale at Red Hat style guide.
supabase-schema
Manage Supabase database schema, migrations, RLS policies, and type generation for the Shopkeeper AI project. Use when user asks about database, schema, tables, migrations, RLS, row level security, types, or Supabase configuration. Also use when user says "database", "schema", "migration", "RLS", "types".
using-based-db
Advanced patterns, query optimization, and best practices for integrating and querying @based/sdk/db in external projects
