数据库
数据库管理与查询
用途与选择建议
这类技能适用于服务接口设计、数据模型变更，以及身份认证和缓存集成。选择时检查支持的数据库或服务商、迁移行为和凭证要求，优先选用能在测试环境验证的工作流。
database-migrations
dadbodgeoff
Safe database migration strategies for zero-downtime deployments. Covers backward-compatible changes, data migrations, and rollback procedures.
postgres-advanced-patterns
organvm-iv-taxis
Advanced PostgreSQL patterns for performance optimization, complex queries, indexing strategies, and database design
Psycopg Skill - Customer Support Tech Enablement
manutej
PostgreSQL adapter for Python - customer support tech enablement for database operations, query optimization, and data management
PostgreSQL Database Administration
manutej
Comprehensive PostgreSQL database administration skill for customer support tech enablement, covering database design, optimization, performance tuning, backup/recovery, and advanced query techniques
database-advanced-optimization
williamzujkowski
'Use SQL (PostgreSQL) when:'
odoo-service
ahmed-lakosha
"Complete Odoo server lifecycle manager — run, deploy, initialize, and manage Odoo across local venv, Docker, and any IDE. Handles server startup/shutdown, environment initialization, database management, Docker orchestration, and IDE configuration for Odoo 14-19."
firestore_patterns
vuralserhat86
Firebase Firestore NoSQL patterns, real-time sync ve security rules rehberi.
database-migration-orm
dmonteroh
"Plan and execute ORM-managed database migrations (Prisma/TypeORM/Sequelize/EF) with zero-downtime patterns, safe backfills, and rollback discipline. Use only for ORM migration tooling (not raw SQL-file migration workflows)."
database-cost-optimization
dmonteroh
"Reduce database infrastructure spend when costs need optimization by analyzing cost drivers, right-sizing compute/storage/replicas, and proposing verified rollback-ready changes without compromising reliability."
database-performance
dmonteroh
"Diagnose and fix database performance issues (slow queries, locks, pool saturation, caching, partitioning) using evidence from metrics and query plans."
postgresql-engineering
dmonteroh
"PostgreSQL-specific schema and data-layer engineering: DDL, data types, constraints, indexing, JSONB, partitioning, RLS, and safe schema evolution. Use when targeting Postgres specifically."
database-architect
dmonteroh
"Design data layers and database architectures by selecting storage models, modeling schemas, and planning safe evolution with tradeoffs and migration/rollback plans. Use when making data-layer decisions or re-architecting storage."
postgresql-admin
pluginagentmarketplace
Administer PostgreSQL - security, roles, permissions, maintenance
database-migration-sql
dmonteroh
"Plan and write forward-only SQL migration files with zero-downtime patterns, validation, rollback guidance, and production safety checks for PostgreSQL, MySQL, and SQL Server."
postgresql-advanced-queries
pluginagentmarketplace
Master advanced PostgreSQL queries - CTEs, window functions, recursive queries
postgresql-replication
pluginagentmarketplace
PostgreSQL streaming replication - setup, monitoring, failover
postgresql-performance
pluginagentmarketplace
Optimize PostgreSQL performance - EXPLAIN ANALYZE, indexing, query tuning
postgresql-monitoring
pluginagentmarketplace
PostgreSQL monitoring - metrics, alerting, observability
postgresql-docker
pluginagentmarketplace
PostgreSQL in containers - Docker, Kubernetes, production configs
postgresql-backup
pluginagentmarketplace
PostgreSQL backup and recovery - pg_dump, pg_basebackup, PITR
postgresql-scaling
pluginagentmarketplace
Scale PostgreSQL - partitioning, connection pooling, high availability
postgresql-extensions
pluginagentmarketplace
Essential PostgreSQL extensions - pg_stat_statements, pg_trgm, PostGIS
postgresql-plpgsql
pluginagentmarketplace
Write PL/pgSQL - functions, procedures, triggers, error handling
postgresql-json
pluginagentmarketplace
Work with JSONB data - queries, indexing, transformations