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

igmarin/rails-agent-skills

Skill Claude CodeCodex

Use when writing new Rails code for the PostgreSQL + Hotwire + Tailwind stack. Not for general architecture review. Trigger words: stack conventions, PostgreSQL, Hotwire, Tailwind, Turbo, Stimulus.

24 11d ago A 49 tokens original MIT

stacklok/toolhive-registry-server

Skill Claude CodeCodex

Deploy the ToolHive Registry Server to a Kind cluster with CloudNativePG (CNPG) PostgreSQL database. Use when you need a production-like PostgreSQL setup with the CNPG operator.

24 6d ago A 46 tokens original Apache-2.0

create-migration

75

tale-project/tale

Skill Claude CodeCodex

Use this skill whenever you change the shape of the 0.5 backend database — a new table, a new column, an index, a constraint, a backfill, or a data reshape. It owns the authoring contract (one numbered .sql file under services/platform/backend/db/migrations/, applied at boot in filename order inside one advisory…

23 3d ago A 152 tokens original MIT

gemini-cli-extensions/alloydb

Skill Claude CodeCodex

Use these skills when you need to provision new AlloyDB clusters and instances, monitor their creation status, and retrieve high-level configuration or health data for the environment.

22 5d ago A 39 tokens original Apache-2.0

gemini-cli-extensions/alloydb

Skill Claude CodeCodex

Use these skills when you need to optimize storage, identify index issues, analyze table statistics, or manage autovacuum and tablespace configurations to maintain peak database health.

22 5d ago A 40 tokens original Apache-2.0

gemini-cli-extensions/alloydb

Skill Claude CodeCodex

Use these skills when you need to troubleshoot slow performance, analyze query execution plans, identify resource-heavy processes, and monitor system-level PromQL metrics.

22 5d ago A 36 tokens original Apache-2.0

claude-memory

79

mkupermann/throughline

Skill Claude CodeCodex

Access the persistent memory database (PostgreSQL claudememory) for long-term context across Claude Code sessions. Triggers on "what do I know about", "memory lookup", "recall", "memory db", "what did we decide about", "similar conversations", "lookup context", "/memory". Provides semantic search, SQL queries and the…

21 6d ago A 81 tokens original MIT

ops-db

81

bezhai/chiwei-platform

Skill Claude CodeCodex

A controlled command for reading data and database structure from three PostgreSQL databases, or submitting database changes for human approval. PostgreSQL is a database system used to store application data.

20 3d ago A 37 tokens original MIT

andrelandgraf/fullstackrecipes

Skill Claude CodeCodex

Choose and create the right Neon branch type for testing and development. Use when users ask about Neon branching, migration testing with real data, isolated test environments, schema-only branch workflows for sensitive data, or branch creation via Neon CLI or Neon MCP. Triggers include "Neon branch", "test migrations…

20 2mo ago A 90 tokens

Hainrixz/claude-db

Skill Claude CodeCodex

Audit connection management — serverless functions opening direct Postgres connections, transaction-mode pooler misuse (PgBouncer / Supabase / prepared statements), and pool sizing against backend maxconnections. Module M15. Feeds the Performance & Scale score.

19 2mo ago A 55 tokens original MIT

honra-io/drizzle-best-practices

Skill Claude CodeCodex

Use this skill whenever the user is working with Drizzle ORM on PostgreSQL. This covers any mention of Drizzle, drizzle-orm, drizzle-kit, drizzle-zod, pgTable, defineRelations, relations(), db.select(), db.query, or insert/update/delete against Postgres. Typical intents to trigger on: Designing or debugging Postgres…

19 3mo ago A 239 tokens original MIT

supabase-community/supabase-plugin

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…

17 15d ago A 182 tokens

db-performance

87

sawrus/agent-guides

Skill Claude CodeCodex

PostgreSQL query performance — EXPLAIN ANALYZE, index design, pgstatstatements, slow query detection, connection pool tuning.

17 12d ago A 32 tokens original MIT

db-migration

88

nikandr-surkov/ai-saas-starter

Skill Claude CodeCodex

Make a database schema change safely — edit schema.ts, generate the migration, review the SQL, apply it. Use for any change under src/db/.

15 +2 1mo ago A 34 tokens original MIT

add-migration

89

Hackbyrd/orbital-express

Skill Claude CodeCodex

Create a database migration to add a new table or alter an existing one (add columns, indexes, constraints) in this Sequelize/Postgres codebase. Use when the user asks to "add a migration", "add/change a column", "create a table migration", or "add an index/constraint".

14 13d ago A 65 tokens original MIT

supabase-security

90

Rodriguespn/improve-skills-workshop-aie-europe

Skill Claude CodeCodex

Use when writing any SQL for Supabase — creating views, tables, functions, or RLS policies. Supabase has several security behaviors that differ from vanilla Postgres in ways that silently create vulnerabilities. This skill makes sure those traps are caught before they ship. Trigger whenever the user is working with…

11 4mo ago A 76 tokens

neon-postgres

91

LeonardoTrapani/better-skills

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…

11 5mo ago A 76 tokens original MIT

polygres-cli

92

Evokoa/polygres-skills

Skill Claude CodeCodex

Use the Polygres CLI to authenticate, create standard or synchronized PostgreSQL projects, select and inspect projects, write one standard-project record through the public Runtime rows surface, import data, apply migrations, configure graph, text, or Polygres AI Context retrieval, manage Runtime keys and durable…

10 14d ago A 97 tokens original Apache-2.0

drizzle-migrations

93

PackmindHub/skillsight

Skill Claude CodeCodex

How to safely add, edit, and verify Drizzle migrations in the skills-observability backend (PostgreSQL + Drizzle ORM). Covers the schema-first generation flow, the strict monotonicity invariant of journal.json when timestamps (whose violation has silently skipped migrations in production), idempotent SQL patterns, and…

9 2mo ago A 227 tokens original Apache-2.0

paradedb-skill

94

paradedb/agent-skills

Skill Claude CodeCodex

Expert guidance on ParadeDB full-text search, vector search, hybrid search (BM25 + semantic), aggregations, and analytics in Postgres. Use when writing ParadeDB queries, creating ParadeDB indexes, indexing vectors, configuring tokenizers, or implementing Elasticsearch-quality search in Postgres.

9 8d ago A 63 tokens original MIT

dublyo/saas-skills

Skill Claude CodeCodex

Build complete Dublyobase backends through remote HTTP MCP, admin REST APIs, and public project APIs. Use when an AI agent needs to connect to a live Dublyobase instance, create projects, design Postgres collections and fields, configure rules, seed records, create app users, upload files, configure…

9 1mo ago A 115 tokens original MIT

db-optimization

96

jdanigo/hydraia

Skill Claude CodeCodex

Use when the bottleneck is database-shaped — slow queries, lock timeouts, connection exhaustion, N+1 patterns, index questions, schema migrations on hot tables. Evidence-first DB playbook for PostgreSQL, MySQL/MariaDB, MongoDB, and Redis backing the db-performance-tuner agent.

8 13d ago A 65 tokens original MIT