PostgreSQL skills

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

data-migration

169

webhook-co/webhook

Skill Claude CodeCodex

Plan and run safe, reversible Postgres schema and data migrations. Use when adding/altering tables or columns, backfilling data, or changing the data model for the webhook metadata store.

0 8d ago A 43 tokens original Apache-2.0

postgresql

170

chenyuan35/aineedhelpfromotherai

Skill Claude CodeCodex

Use when working with database queries, schema, connection pool, JSONB columns, or any handler/lib that interacts with PostgreSQL. Covers pg.Pool patterns, ensureTable(), JSONB operations, and parameterized queries. Do NOT use for non-DB backend code.

0 3d ago A 57 tokens

postgres-aiops

171

AIops-tools/Postgres-AIops

Skill Claude CodeCodex

Part of postgres-aiops

Use this skill whenever the user needs to operate or troubleshoot a PostgreSQL server/cluster as a DBA — a one-shot cluster health overview; server reads (version/uptime, settings, extensions, databases, roles); activity (sessions, idle-in-transaction, long-running queries, locks); query stats (pgstatstatements top-N…

0 7d ago A 443 tokens original MIT

vault-inspect

172

Edu963/ocultar

Skill Claude CodeCodex

Vault Inspection Tool. Safely queries the local DuckDB or PostgreSQL vault. Lists token counts, types, and encryption status. Use when: "check vault", "list tokens", "vault status", "inspect database".

0 16d ago A 49 tokens

nexql-mcp-dev

173

NexQL-OSS/mcp

Skill Claude CodeCodex

Guides phased implementation and testing of the standalone Rust nexql-mcp Postgres MCP server. Use when working in this repo, implementing nexql-mcp crates, porting from pro/src/mcp or dbindex, writing MCP tools, or starting a new session here.

0 8d ago A 62 tokens GPL-3.0

backendgen

174

SiTouhemi/Backendgen

Skill Claude CodeCodex

Generate, validate, regenerate, and test deterministic NestJS, Prisma, and PostgreSQL backends from compact backendcompiler.dev/v1 YAML or JSON specifications. Use when an AI-built frontend needs a backend, when creating CRUD/auth/organizations/reservations/notifications/webhooks/jobs/uploads features, when changing…

0 1mo ago A 82 tokens original Apache-2.0

neon-postgres

175

meridianmcp/Meridian

Skill Claude CodeCodex

Guides and best practices for working with Neon Serverless Postgres. Covers setup, connection methods, branching, autoscaling, scale-to-zero, read replicas, connection pooling, Neon Auth, and the Neon CLI, MCP server, REST API, TypeScript SDK, and Python SDK. Use when users ask about "Neon setup", "connect to Neon"…

0 2d ago A 151 tokens

prisma-postgres-setup

176

RitikaxG/commerce-ops-mcp

Skill Claude CodeCodex

Set up a new Prisma Postgres database and connect it to a local project using the Management API. Use when asked to "set up a database", "create a Prisma Postgres project", "get a connection string", "connect my app to Prisma Postgres", or "provision a database".

0 28d ago A 67 tokens

mcp-psycopg2

177

daedalus/mcp-psycopg2

Skill Claude CodeCodex

MCP server exposing PostgreSQL database functionality via psycopg2.

0 4mo ago A 0 tokens original MIT

claude

178

lobster-kit/mcp-server-lobsterdb

Skill Claude CodeCodex

You have access to LobsterDB — managed PostgreSQL databases. Provision a database instantly, run SQL, evolve the schema, take snapshots. No setup, no API keys, no human signup required.

0 5mo ago A 0 tokens original MIT

lobsterdb

179

lobster-kit/mcp-server-lobsterdb

Skill Claude CodeCodex

Managed PostgreSQL for agents. Provision databases, run SQL, evolve schemas. No API keys, no human signup.

0 5mo ago A 27 tokens original MIT

lobsterdb

180

lobster-kit/mcp-server-lobsterdb

Skill Claude CodeCodex

Managed PostgreSQL for agents. Provision databases, run SQL, evolve schemas. No API keys, no human signup.

0 5mo ago C 27 tokens original MIT

neon-postgres

181

mckaystu/ambit-iq-mcp

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…

0 3mo ago A 76 tokens copy · 100% MIT

deadlock-transaction

182

irsyadjpp/postgres-mcp-server

Skill Claude CodeCodex

Part of postgres

Analyze and resolve deadlock patterns, lock contention, and transaction management issues. Use when investigating stuck queries, lock timeouts, deadlock errors, or transaction isolation problems.

0 27d ago A 39 tokens original ISC

irsyadjpp/postgres-mcp-server

Skill Claude CodeCodex

Part of postgres

Monitor and optimize PostgreSQL maintenance operations including autovacuum tuning, vacuum progress, huge pages, and WAL management. Use when investigating table bloat, vacuum issues, or system resource optimization.

0 27d ago A 42 tokens original ISC

cdmmca2007/postgres-mcp-server-main-demo

Skill Claude CodeCodex

This repository contains a small Python-based Model Context Protocol (MCP) server for interacting with a PostgreSQL database. It exposes database discovery and querying tools so an MCP client can inspect tables, fetch schema details, run safe SELECT queries, and gather basic database statistics.

0 1mo ago A 0 tokens original MIT

terrabase-db-changes

185

Terrabase-in/terrabase

Skill Claude CodeCodex

Use when making Postgres schema or migration changes (CREATE/ALTER/DROP TABLE, indexes, columns, constraints, backfills) IN A PROJECT THAT DECLARES A TERRABASE TARGET (a TERRABASEDATABASEURL in its .env). Routes the change through terrabase's MCP tools for a deterministic safety analysis plus a local-Qwen plan, and…

0 21d ago A 98 tokens original Apache-2.0

johnnyclem/hypervault-mcp

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.

0 18d ago A 41 tokens

db-migration

187

nacre-work/nacre

Skill Claude CodeCodex

Use when changing the PostgreSQL schema, adding a migration under packages/core/migrations, or touching row-level security, the grants table, tombstones, or the audit table. Triggers on "migration", "schema", "DDL", "RLS", "row level security", "ALTER TABLE", "new column", "index" in a database context.

0 4d ago A 76 tokens original Apache-2.0

vikasudasi/skill-vault

Skill Claude CodeCodex

Postgres fundamentals for when you outgrow SQLite — psql, schema design, constraints, indexes, transactions, EXPLAIN, and connection pooling.

0 17d ago A 38 tokens original Apache-2.0

neon-postgres

189

Musharrafjamal/mcp-commerce

Skill Claude CodeCodex

Guides and best practices for working with Lakebase Postgres, the database behind Neon. Covers setup, connection methods and drivers, pooled vs direct connections, branching, schema migrations, autoscaling, scale-to-zero, instant restore, read replicas, connection pooling, IP allow lists, and logical replication. Use…

0 23d ago A 163 tokens

neon

190

Musharrafjamal/mcp-commerce

Skill Claude CodeCodex

Overview of Neon, a complete set of cloud backend primitives for apps and agents, spanning Lakebase Postgres, Auth, the Data API, Object Storage, Compute Functions, and the AI Gateway. Start here to route to the right Neon skill, set up the CLI or MCP server, and follow the branch-first workflow. Use when "Neon" or…

0 23d ago A 132 tokens

prisma-postgres-setup

191

prashantkumar342/code-with-softority

Skill Claude CodeCodex

Set up a new Prisma Postgres database and connect it to a local project using the Management API. Use when asked to "set up a database", "create a Prisma Postgres project", "get a connection string", "connect my app to Prisma Postgres", or "provision a database".

0 22d ago A 67 tokens

neon-postgres

192

ibraheemmawwal/catalogue-api

Skill Claude CodeCodex

Guides and best practices for working with Lakebase Postgres, the database behind Neon. Covers setup, connection methods and drivers, pooled vs direct connections, branching, schema migrations, autoscaling, scale-to-zero, instant restore, read replicas, connection pooling, IP allow lists, and logical replication. Use…

0 10d ago A 163 tokens

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: