slow-query
145Skill Claude CodeCodex
A guide for diagnosing and improving slow SQL queries in PolarDB for PostgreSQL, a managed PostgreSQL database service. It is based on practical cases.
893 tagged PostgreSQL, measured the same way as everything else here.
Browse within: antigravity 50postgresql 30gemini 28nextjs 23ai-skills 19gemini-cli 19sql 15supabase 14aws 13claude-ai 13claude-plugin 13claude-marketplace 12python3 11geo 10
Skill Claude CodeCodex
A guide for diagnosing and improving slow SQL queries in PolarDB for PostgreSQL, a managed PostgreSQL database service. It is based on practical cases.
Cyvid7-Darus10/claude-code-config
Skill Claude CodeCodex
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.
Skill Claude CodeCodex
Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
itokun99/superspec-ai-workflow
Skill Claude CodeCodex
Database migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL, and common ORMs (Prisma, Drizzle, Kysely, Django, TypeORM, golang-migrate).
itokun99/superspec-ai-workflow
Skill Claude CodeCodex
Expert-level PostgreSQL database administration, advanced queries, performance tuning, and production operations.
Skill Claude CodeCodex
Enforce correct financial workflows using durable state, idempotency, immutability, and concurrency guards (Drizzle + Postgres).
Skill Claude CodeCodex
Enforce PII table separation + envelope encryption + KEK rotation (Web Crypto API + Postgres + Drizzle).
Skill Claude CodeCodex
Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill BEFORE writing or changing anything that lives in a Postgres database: creating or altering tables and columns (including choosing column types), schema design, migrations and declarative schema files, RLS policies and the…
Skill Claude CodeCodex
Write PostgreSQL trigger functions and migrations for this Supabase project. Enforces all security and performance rules derived from the project's migration history to avoid Supabase advisor warnings (lints 0011, 0028, 0029).
Skill Claude CodeCodex
PostgreSQL database documentation - SQL queries, database design, administration, performance tuning, and advanced features. Use when working with PostgreSQL databases, writing SQL, or managing database systems.
Skill Claude CodeCodex
Write and test Supabase/Postgres Row-Level Security policies so users can only access their own rows. Use when a table holds user data, when enabling RLS, or when auditing access control on Supabase.
Skill Claude CodeCodex
Scaffold a shared Drizzle ORM + PostgreSQL database package in a Bun/Turborepo monorepo. Pooled singleton client with connection retry, org-scoped service layer with AsyncResult, zod validation, transactions, soft-deletes, error handling, and migrations. Run /dlc-scaffold-monorepo first.
Skill Claude CodeCodex
Use when writing, reviewing, or running tests for anything Postgres-related in a Supabase project — database schema, RPCs / SECURITY DEFINER functions, triggers, RLS policies, migrations, extensions. Triggers: pgTAP, supabase test db, .test.sql files, hastable/hascolumn/resultseq/throwsok/livesok, RLS policy testing…
Skill Claude CodeCodex
PostgreSQL RAG Data Ingestion and Retrieval Operations Tool - supports keyword search (BM25), vector search, and hybrid search.
Skill Claude CodeCodex
Part of seenode
Create, inspect, update, rotate, and link Seenode MySQL/PostgreSQL databases to applications via MCP. Use when the user asks about Seenode databases, provisioning, connection wiring, password rotation, DB metrics, or renaming/moving a database. Prefer linkdatabasetoapplication — never paste DB passwords.
Skill Claude CodeCodex
Part of nlqdb-memory
Give this agent persistent, queryable memory over the nlqdb MCP server. Use whenever the agent needs to remember something across sessions, recall what it stored, or aggregate over its memory (GROUP BY / JOIN / counts / trends) — backed by a real Postgres it queries in plain English, not a vector store.
Skill Claude CodeCodex
Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
robertgorsuch/AI-JasperReports-Generator
Skill Claude CodeCodex
Part of jasper-deploy
Design, compile, and deploy JasperReports artifacts to JasperReports Server over REST v2. Use for scaffolding a report from SQL, generating or editing a JR7 .jrxml, compiling/deploying/verifying reports, composing dashboards, managing datasources, Domains, ad hoc views, OLAP/Mondrian, themes, input controls…
Jiangxianze/spring-agent-skills
Skill Claude CodeCodex
Review Flyway SQL migrations for PostgreSQL or MySQL production safety. Use when creating or reviewing versioned or repeatable migration files, pull requests with DDL or backfills, zero-downtime schema changes, expand-contract rollouts, index creation, constraint validation, type changes, renames, or destructive…
michelgrolet/people-memory-mcp
Skill Claude CodeCodex
Part of people-memory
Set up or reconfigure People Memory for an existing Codex, Claude Code, Cursor, or other MCP-capable agent; create a minimal personal agent if needed; choose local PostgreSQL or hosted Supabase; install the schema, MCP, UI, and durable memory instructions; ask which LinkedIn, Google Contacts, WhatsApp, Gmail…
Skill Claude CodeCodex
Diagnose and fix excessive Postgres egress (network data transfer) in a codebase. Use when a user mentions high database bills, unexpected data transfer costs, network transfer charges, egress spikes, "why is my Neon bill so high", "database costs jumped", SELECT optimization, query overfetching, reduce Neon costs…
Skill Claude CodeCodex
Guides and best practices for working with Neon Serverless Postgres. Covers getting started, local development with Neon, choosing a connection method, Neon features, authentication (@neondatabase/auth), PostgREST-style data API (@neondatabase/neon-js), Neon CLI, and Neon's Platform API/SDKs. Use for any Neon-related…
Skill Claude CodeCodex
Persistent memory across sessions and tools for this project, backed by a local Postgres graph. Use when the user states a decision, corrects you, states a preference, or says "remember this"; and at session start, or any time recalling prior context would save the user from re-explaining something they already told a…
Skill Claude CodeCodex
Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
At most 3 mods per repository are shown here, and a mod shipped inside a plugin is left to that plugin's page — the rest are on their repository pages: