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

slow-query

145

polardb/polardb-pg-skills

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.

2 2mo ago A 28 tokens

postgres-patterns

146

Cyvid7-Darus10/claude-code-config

Skill Claude CodeCodex

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

2 1mo ago A 28 tokens copy · 89% MIT

RublerubitZ/duing

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.

2 2d ago A 41 tokens

database-migrations

148

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).

2 2mo ago A 56 tokens

pii-protection

151

cjerochim/compound-workflow

Skill Claude CodeCodex

Enforce PII table separation + envelope encryption + KEK rotation (Web Crypto API + Postgres + Drizzle).

2 2mo ago A 29 tokens

tomas-lp/hackIAthon-2026-nkc

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…

2 7d ago A 182 tokens

db-trigger

153

maxitect/claude-config

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).

2 1mo ago A 50 tokens

postgresql

154

ShunmeiCho/dotclaude

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.

2 7mo ago A 40 tokens

rls-policy

155

m-binimran/dev-pack

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.

2 2mo ago A 46 tokens original MIT

dlc-scaffold-db

156

delacournz/agent-skills

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.

2 19d ago A 73 tokens

supabase-testing

157

vincenzodomina/ai

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…

2 1mo ago A 97 tokens

postgres-rag-skill

158

wjcwjc77/agentic-postgres-rag

Skill Claude CodeCodex

PostgreSQL RAG Data Ingestion and Retrieval Operations Tool - supports keyword search (BM25), vector search, and hybrid search.

2 10mo ago A 32 tokens

databases

159

seenode/seenode-agent-plugin

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.

2 24d ago A 66 tokens original MIT

nlqdb-memory

160

nlqdb/nlqdb

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.

1 2d ago A 70 tokens

Rishav0123/sentimatix

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.

1 2mo ago A 41 tokens

jasper-deploy

162

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…

1 5d ago B 152 tokens original Apache-2.0

flyway-safe-migration

163

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…

1 25d ago A 80 tokens original Apache-2.0

setup-people-memory

164

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…

1 9d ago A 107 tokens original MIT

sayuru-akash/web-audit-mcp

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…

1 3mo ago A 117 tokens

neon-postgres

166

sayuru-akash/web-audit-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…

1 3mo ago A 76 tokens

echo-memory

167

ayushcodes10/echo-mem

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…

1 2d ago A 75 tokens original Apache-2.0

Guild-Wars-MCP/GW2_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 1mo ago A 41 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: