Database Skills
PostgreSQL、MySQL、MongoDB、Redis、SQL优化
sql-optimization-patterns
Master SQL query optimization, indexing strategies, and EXPLAIN analysis.
database-migration
Execute database migrations with zero-downtime strategies and rollback procedures.
postgresql-table-design
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints.
postgres-schema-design
Comprehensive PostgreSQL-specific table design reference covering data types, indexing, constraints.
analyzing-query-performance
Query performance analysis with comprehensive guidance and automation.
managing-database-migrations
Schema migration management with comprehensive guidance and automation.
managing-database-sharding
Horizontal sharding strategies with comprehensive guidance and automation.
optimizing-sql-queries
Query performance analysis with comprehensive guidance and automation.
generating-orm-code
ORM model and code generation with comprehensive guidance and automation.
automating-database-backups
Automate database backup processes with scheduling and encryption.
databases
Work with MongoDB (document database) and PostgreSQL (relational database).
postgresql
PostgreSQL database documentation - SQL queries, database design, administration.
timescaledb
TimescaleDB - PostgreSQL extension for high-performance time-series analytics.
supabase-usage
Use when querying Supabase, listing tables, getting schema, or working with RLS policies.
database-design
Database schema design, optimization, and migration patterns for PostgreSQL, MySQL, and NoSQL.