database-migrations-sql-migrations
SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, SQL Server
SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, SQL Server
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
Use when generating URL slugs in Stacks โ creating unique slugs with database collision detection, the uniqueSlug function with table/column configuration, or basic slugification. Covers @stacksjs/slug.
Design and generate Convex database schemas with proper validation, indexes, and relationships. Use when creating schema.ts or modifying table definitions.
Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
Database specialist for SQL, NoSQL, and vector database modeling, schema design, normalization, indexing, transactions, integrity, concurrency control, backup, capacity planning, data standards, anti-pattern review, and compliance-aware database design. Use for database, schema, ERD, table design, document model, vector index design, RAG retrieval architecture, migration, query tuning, glossary, capacity estimation, backup strategy, database anti-pattern remediation work, and ISO 27001, ISO 27002, or ISO 22301-aware database recommendations.
Schema awareness - read before coding, type generation, prevent column errors
Consult PostgreSQL's pg_dump implementation for guidance on system catalog queries and schema extraction when implementing pgschema features
Consult PostgreSQL's parser and grammar (gram.y) to understand SQL syntax, DDL statement structure, and parsing rules when implementing pgschema features
Connect to live PostgreSQL database to validate schema assumptions, compare pg_dump vs pgschema output, and query system catalogs interactively
ๆไฝๆฐๆฎๅบใ็ผๅ่ฟ็งปใ่ฎพ่ฎก schemaใ็ฎก็ไบๅกใๅๅปบ็ดขๅผใไฝฟ็จ Prisma/Sequelize/TypeORM/Mongoose ็ญ ORM๏ผๆๆง่ก SQL/NoSQL ๆไฝๆถไฝฟ็จใ
ไผๅๆง่ฝใๅค็ๆฐๆฎๅบๆฅ่ฏขใๅฎ็ฐ็ผๅญใๆๅ ่ฝฝใๅ้กตใๆๅ ไผๅ๏ผๆไปฃ็ ๆถๅๅคงๆฐๆฎ้ๅพช็ฏใๅนถๅๆไฝใๅ ๅญ็ฎก็ๆถไฝฟ็จใ
Google BigQuery data warehouse queries and schema inspection. Use when running SQL queries, listing datasets/tables, or inspecting table schemas in BigQuery.
PostgreSQL database inspection and queries. Use when investigating table schemas, running queries, checking locks, replication status, or long-running queries.
Snowflake data warehouse queries and schema inspection. Use when running SQL queries against Snowflake, listing tables, or inspecting schemas.
Analyze database query performance with execution plans and index recommendations
Translate SQL queries between different database dialects with function mapping and optimization
Searches M&A and funding databases for relevant comparable transactions
PostgreSQL query optimization, indexing, full-text search, JSONB, and advanced features.
Prisma ORM schema design, migrations, relations, query optimization, and database integration patterns.