PostgreSQL · Query optimization

Gives the agent Postgres rules to consult before writing or changing tables, queries, indexes, RLS policies or migrations, and when diagnosing slow queries.

supabase/agent-skills

Indexes reference files on Postgres schema design, indexing, partitioning, query patterns, MVCC and VACUUM, and PlanetScale-specific operations.

planetscale/database-skills

PostgreSQL database documentation - SQL queries, database design, administration, performance tuning, and advanced features. Use when working with…

2025Emma/vibe-coding-cn

Database operations runbook — backup, recovery, performance tuning, troubleshooting.

OpenDCAI/DataMind

Guides scalability and performance work for VeloxDB's Tauri + Rust PostgreSQL backend and React + TanStack frontend.

veloxbase/veloxdb

Delegates dbt and warehouse tasks such as lineage, migrations and cost attribution to the altimate-code CLI agent and relays its answer back.

AltimateAI/data-engineering-skills

Design, refactor and diagnose Paro's staged optimizer, using EXPLAIN COMPILE for planning and EXPLAIN ANALYZE for execution.

zunor/paro

MUST USE when investigating performance issues on a ClickHouse-managed Postgres instance.

ClickHouse/agent-skills

Design database schemas with Prisma/Drizzle, PostgreSQL index strategy (B-tree, GIN, GiST, BRIN, Hash), query optimization (EXPLAIN ANALYZE), migration safety (expand/contract, zero-downtime), and…

EliasOulkadi/shokunin

CloudBase PostgreSQL access-pattern and slow-query quality guidance.

TencentCloudBase/CloudBase-AI-Toolkit

Database guidance for PostgreSQL, MongoDB, Redis and Oracle plus Neon, Supabase and Firestore: schema design, indexing, query tuning and cloud database choice.

modu-ai/moai-adk

PostgreSQL database patterns for query optimization, schema design, indexing, and security.

ThibautBaissac/rails_ai_agents

PostgreSQL query optimization, JSONB operations, advanced indexing strategies, partitioning, connection management, and database administration.

cin12211/orca-q

Tunes PostgreSQL and MySQL performance by analyzing slow queries and execution plans, designing indexes, rewriting queries and adjusting configuration, one validated change at a time.

Jeffallan/claude-skills

Tunes and administers PostgreSQL: EXPLAIN-driven query tuning, index choice, JSONB, extensions, streaming or logical replication, VACUUM and pg_stat monitoring.

Jeffallan/claude-skills

Optimizes SQL queries and designs schemas using CTEs, window functions, covering indexes and EXPLAIN ANALYZE, with notes on dialect differences between major databases.

Jeffallan/claude-skills

Translate natural language to SQL, optimize query performance, and interpret EXPLAIN plans for SQLite and PostgreSQL.

zebbern/claude-code-guide

Automatically discover database skills when working with SQL, PostgreSQL, MongoDB, Redis, database schema design, query optimization, migrations, connection pooling, ORMs, or database selection.

rand/cc-polymath

PostgreSQL database optimization workflow for query tuning, indexing strategies, performance analysis, and production database management.

davila7/claude-code-templates

A skill your agent uses when investigating slow queries, analyzing execution plans, or optimizing database performance.

AratKruglik/claude-laravel

Trigger: "profile Materialize", "check memory usage", "analyze binary size", "debug performance", or mentions profiling, samply, heaptrack, flame graphs, memory checking, binary size, slow queries…

MaterializeInc/materialize

PostgreSQL expert for query optimization, indexing, extensions, and database administration

RightNow-AI/openfang

Provisions and manages Aurora DSQL clusters, connects via psql or DSQL Connectors, manages schemas, runs queries, migrates from MySQL, diagnoses query plans, and develops apps on serverless…

aws/agent-toolkit-for-aws

A skill your agent uses when investigating slow queries, analyzing execution plans, or optimizing database performance.

zebbern/claude-code-guide

PostgreSQL-specific development assistant focusing on unique PostgreSQL features, advanced data types, and PostgreSQL-exclusive capabilities.

github/awesome-copilot

Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server…

github/awesome-copilot

Query optimization, indexing strategies, and database performance tuning for PostgreSQL and MySQL

rohitg00/awesome-claude-code-toolkit

Expert guide for diagnosing and fixing Odoo performance issues: slow queries, worker configuration, memory limits, PostgreSQL tuning, and profiling tools.

sickn33/agentic-awesome-skills

Master SQL and database queries across multiple systems. An agent skill from jamesrochabrun/skills.

jamesrochabrun/skills

PostgreSQL database patterns for query optimization, schema design, indexing, and security.

affaan-m/ECC

Run read-only SQL against the local Postgres app database (SELECT, EXPLAIN, EXPLAIN ANALYZE on SELECT).

PostHog/posthog

Runs read-only production database analysis through PostHog's internal Metabase instances.

PostHog/posthog

Optimize SQL query performance through EXPLAIN analysis, indexing strategies, and query rewriting for PostgreSQL, MySQL, and SQL Server.

ancoleman/ai-design-components

Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, diagnose cluster performance, load data, and develop applications with a serverless, distributed…

awslabs/agent-plugins

Set up Grafana Cloud Database Observability for MySQL and PostgreSQL — enables pgstatstatements / Performance Schema, creates a least-privilege monitoring user, configures the…

grafana/skills

Profiles slow PostHog API endpoints when the main cost is in Postgres or Python.

PostHog/posthog

Process use when you need to work with database indexing. An agent skill from jeremylongshore/tons-of-skills-marketplace.

jeremylongshore/tons-of-skills-marketplace

Execute use when you need to work with query optimization. An agent skill from jeremylongshore/tons-of-skills-marketplace.

jeremylongshore/tons-of-skills-marketplace

Execute use when you need to work with query optimization. An agent skill from jeremylongshore/tons-of-skills-marketplace.

jeremylongshore/tons-of-skills-marketplace

Expert SQL developer specializing in complex query optimization, database design, and performance tuning across PostgreSQL, MySQL, SQL Server, and Oracle.

xiaoyuge886/aigc

Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across SQL databases (PostgreSQL, SQL Server, Oracle).

totvs/engpro-advpl-tlpp-skills

SQL query optimization and database performance specialist. An agent skill from aiskillstore/marketplace.

aiskillstore/marketplace

Optimize EF Core (Npgsql/PostgreSQL) queries in the .NET API — fix N+1, choose tracking modes, use compiled queries, split queries, and avoid translation traps.

atherio-danp/cde-dotnetcc

Validate database integrity, test migrations forward and backward, verify schema constraints, manage seed data, detect migration drift, and identify query performance issues.

petrkindlmann/qa-skills

PostgreSQL optimization including indexes, query plans, partitioning, JSONB operations, and connection pooling

rohitg00/awesome-claude-code-toolkit

DB schema design and query tuning: normalization, indexing, N+1, transactions, EXPLAIN.

softspark/ai-toolkit

Deep Supabase diagnostics: pgstatstatements for slow queries, lock debugging with pglocks, connection leak detection, RLS policy conflicts, Edge Function cold starts, and Realtime connection drop…

jeremylongshore/tons-of-skills-marketplace

Application performance tuning, JVM optimization, database query tuning, Vaadin UI performance

Hack23/cia