sql-databases
22
postgres-best-practices
Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
dirnbauer
databases
sorting
stars
current ordering strategy
query
all entries
refine the visible subset
sql-databases
22
postgres-patterns
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.
skateddu
databases
sql-databases
22
database-engineer
[production-grade internal] Designs and optimizes database systems — schema design, query optimization, migration management, indexing strategy, scaling patterns, and multi-database architecture. Routed via the production-grade orchestrator.
buiphucminhtam
databases
sql-databases
22
database-optimizer
Expert database specialist focusing on schema design, query optimization, indexing strategies, and performance tuning for PostgreSQL, MySQL, and modern databases like Supabase and PlanetScale.
Prorise-cool
databases
sql-databases
22
postgresql-database
Development patterns with PostgreSQL via FireDAC — connection, PL/pgSQL, sequences, JSONB, UPSERT, full-text search, migrations
delphicleancode
databases
sql-databases
22
postgresql-database
Development patterns with PostgreSQL via FireDAC — connection, PL/pgSQL, sequences, JSONB, UPSERT, full-text search, migrations
delphicleancode
databases
sql-databases
21
bun-sqlite
Use for bun:sqlite, SQLite operations, prepared statements, transactions, and queries.
secondsky
databases
sql-databases
21
db-handler
Manage database schemas, Drizzle ORM, migrations, and data modeling.
Indie-Kit
databases
sql-databases
21
database-schema-designer
This skill should be used when designing database schemas for SQL or NoSQL databases. It provides normalization guidelines, indexing strategies, migration patterns, and performance optimization.
kumaran-is
databases
sql-databases
21
sql-pro
Masters modern SQL across PostgreSQL, BigQuery, Snowflake, and hybrid OLTP/OLAP systems — covering advanced query techniques, dimensional modeling, time-series SQL, and data warehouse patterns. Use when writing complex analytics SQL, designing cloud database schemas, or optimizing cross-platform SQL workloads.
kumaran-is
databases
sql-databases
21
sql-optimization-patterns
Transforms slow PostgreSQL queries into fast operations through systematic EXPLAIN ANALYZE, indexing strategies, N+1 elimination, cursor pagination, and materialized views. Use when diagnosing slow queries, optimizing database performance, or designing index strategies — always profile before optimizing.
kumaran-is
databases
sql-databases
21
postgres-best-practices
Supabase PostgreSQL best practices library — 33 impact-rated rules (CRITICAL→LOW) covering connection pooling, RLS, locking, VACUUM, full-text search, and JSONB indexing. Use when writing, reviewing, or optimizing PostgreSQL queries, schema, or configuration.
kumaran-is
databases
sql-databases
21
postgresql
PostgreSQL-specific schema design reference for advanced data types (ENUM, array, range, network, domain), storage internals (MVCC, HOT updates, TOAST, heap), and advanced constraints (EXCLUDE, generated columns). Use when designing PostgreSQL schemas, choosing data types, working with extensions (pgvector, PostGIS, TimescaleDB), or handling schema evolution safely without downtime.
kumaran-is
databases
sql-databases
21
pg-vacuum-tuning
Monitors and tunes PostgreSQL vacuum operations including autovacuum configuration, vacuum progress tracking, wraparound prevention, and per-table vacuum strategy. Provides tuning recommendations for high-churn OLTP and large analytical tables.
isdaniel
databases
sql-databases
21
pg-performance-baseline
Generates a comprehensive PostgreSQL performance baseline report capturing health metrics, query workload patterns, table statistics, configuration settings, index utilization, and I/O patterns. Designed for before/after comparison when making changes.
isdaniel
databases
sql-databases
21
pg-index-optimization
Performs comprehensive PostgreSQL index optimization including unused index cleanup, duplicate detection, missing index recommendations, and hypothetical index testing with HypoPG. Provides actionable CREATE/DROP INDEX statements with estimated impact.
isdaniel
databases
sql-databases
21
pg-query-rewrite
Guides SQL query optimization through execution plan analysis and common rewrite patterns. Covers subquery-to-JOIN conversion, CTE materialization control, OR-to-UNION, NOT IN-to-NOT EXISTS, pagination optimization, and SELECT * elimination. Uses analyze_query with format and settings parameters for deep plan analysis.
isdaniel
databases
sql-databases
21
pg-health-check
Performs comprehensive PostgreSQL database health assessments covering connections, cache performance, locks, replication, wait events, active queries, and configuration review. Produces a scored health report with prioritized recommendations.
isdaniel
databases
sql-databases
20
spotiarr-prisma
Prisma ORM patterns for Spotiarr's SQLite-backed backend. Trigger: When writing database queries, migrations, or Prisma schemas.
mralexsaavedra
databases
sql-databases
20
mongodb-migration-expert
Database schema design, indexing, and migration guidance for MongoDB-based applications.
shipshitdev
databases