database-migrations-sql-migrations
SQL database migrations with zero-downtime strategies for
moai-domain-database
>
moai-platform-neon
>
moai-platform-supabase
>
database-migrations-sql-migrations
SQL database migrations with zero-downtime strategies for
database-design-patterns
Database schema design including normalization, denormalization, indexes, migrations, foreign keys, constraints, and query optimization. Covers PostgreSQL, MySQL, and general SQL patterns. Use when designing database schemas, optimizing queries, setting up migrations, or debugging performance issues.
database-architecture
MANDATORY when designing schemas, writing migrations, creating indexes, or making architectural database decisions - enforces PostgreSQL 18 best practices including AIO, UUIDv7, temporal constraints, and modern indexing strategies
postgres-rls
MANDATORY when touching auth tables, tenant isolation, RLS policies, or multi-tenant database code - enforces Row Level Security best practices and catches common bypass vulnerabilities
postgres
Execute read-only SQL queries against multiple PostgreSQL databases. Use when: (1) querying PostgreSQL databases, (2) exploring database schemas/tables, (3) running SELECT queries for data analysis, (4) checking database contents. Supports multiple database connections with descriptions for intelligent auto-selection. Blocks all write operations (INSERT, UPDATE, DELETE, DROP, etc.) for safety.
backend-development
Build robust backend systems with modern technologies (Node.js, Python, Go, Rust), frameworks (NestJS, FastAPI, Django), databases (PostgreSQL, MongoDB, Redis), APIs (REST, GraphQL, gRPC), authentication (OAuth 2.1, JWT), testing strategies, security best practices (OWASP Top 10), performance optimization, scalability patterns (microservices, caching, sharding), DevOps practices (Docker, Kubernetes, CI/CD), and monitoring. Use when designing APIs, implementing authentication, optimizing database queries, setting up CI/CD pipelines, handling security vulnerabilities, building microservices, or developing production-ready backend systems. | Sử dụng khi xây dựng API, server, backend, máy chủ, xử lý dữ liệu, endpoint, microservices.
databases
Work with MongoDB (document database, BSON documents, aggregation pipelines, Atlas cloud) and PostgreSQL (relational database, SQL queries, psql CLI, pgAdmin). Use when designing database schemas, writing queries and aggregations, optimizing indexes for performance, performing database migrations, configuring replication and sharding, implementing backup and restore strategies, managing database users and permissions, analyzing query performance, or administering production databases. | Sử dụng khi làm việc với cơ sở dữ liệu, database, SQL, query, truy vấn, schema, migration.
postgres-setup
Set up PostgreSQL database with standardized schema.sql pattern. Use when starting a new project that needs PostgreSQL, setting up database schema, or creating setup scripts for postgres.
postgresql-performance
Optimize PostgreSQL performance - EXPLAIN ANALYZE, indexing, query tuning
postgresql-fundamentals
Master PostgreSQL SQL fundamentals - data types, tables, constraints, schema design
postgresql-docker
PostgreSQL in containers - Docker, Kubernetes, production configs
postgresql-backup
PostgreSQL backup and recovery - pg_dump, pg_basebackup, PITR
postgresql-monitoring
PostgreSQL monitoring - metrics, alerting, observability
postgresql-advanced-queries
Master advanced PostgreSQL queries - CTEs, window functions, recursive queries
postgresql-json
Work with JSONB data - queries, indexing, transformations
postgresql-replication
PostgreSQL streaming replication - setup, monitoring, failover
postgresql-plpgsql
Write PL/pgSQL - functions, procedures, triggers, error handling
postgresql-scaling
Scale PostgreSQL - partitioning, connection pooling, high availability
postgresql-admin
Administer PostgreSQL - security, roles, permissions, maintenance
postgresql-extensions
Essential PostgreSQL extensions - pg_stat_statements, pg_trgm, PostGIS
sqlalchemy-postgres
Expert guidance for SQLAlchemy 2.0 + Pydantic + PostgreSQL. Use when setting up database layers, defining models, creating migrations, or any database-related work. Automatically activated for DB tasks.
