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
postgresql
PostgreSQL administration and setup including installation, configuration, backup/recovery, replication, and high-availability. Learn production PostgreSQL operations.
design-postgres-tables
Comprehensive PostgreSQL-specific table design reference covering data types, indexing, constraints, performance patterns, and advanced features
databases
Master relational and NoSQL databases. Learn PostgreSQL, MySQL, MongoDB, Redis, and other technologies for data persistence, optimization, and scaling.
databases
Game data persistence with player profiles, leaderboards, inventory systems using Redis and PostgreSQL
sql-expert
Expert SQL query writing, optimization, and database schema design with support for PostgreSQL, MySQL, SQLite, and SQL Server. Use when working with databases for: (1) Writing complex SQL queries with joins, subqueries, and window functions, (2) Optimizing slow queries and analyzing execution plans, (3) Designing database schemas with proper normalization, (4) Creating indexes and improving query performance, (5) Writing migrations and handling schema changes, (6) Debugging SQL errors and query issues
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.
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.
postgresql-skill
This skill provides PostgreSQL-specific patterns for database design, optimization, and transaction management
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.
Page 2 of 3 · 48 results