PostgreSQL skills

993 tagged PostgreSQL, measured the same way as everything else here.

Browse within: agent-memory 157graph-database 153skills 73cursor 71postgresql 67antigravity 65ai-coding 55mcp-server 48agents 47agentic-ai 45claude-code-plugin 42cli 41supabase 37ai-tools 35

neondatabase/vercel-marketplace-neon

Skill Claude CodeCodex ✓ vendor

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…

not rated 25 2mo ago A 117 tokens copy · 86% Apache-2.0

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…

not rated 22 5mo ago A 239 tokens original MIT

backup-restore

27

sawrus/agent-guides

Skill Claude Code

PostgreSQL backup and restore with pgBackRest — full/incremental/WAL, PITR, K8s CronJob scheduling, and restore verification.

not rated 19 yesterday A SkillSpector: pass 36 tokens original MIT

Knuckles-Team/vector-mcp

Skill Claude CodeCodex

Select and connect the right vector-store backend for the vector-mcp MCP server — chromadb, postgres/pgvector, qdrant, couchbase, or mongodb — and supply the correct dbtype/connection parameters that every collection and search call needs. Use when the agent must decide which engine to target, wire up…

not rated 16 +1 3d ago A SkillSpector: pass 113 tokens original MIT

squish

29

michielhdoteth/squish-memory

Skill Claude CodeCodex

ALWAYS use this skill when working with agents, memory, context, persistence, or AI agent state. Use when the user mentions: 'the agent forgot', 'save this', 'remember that', 'context is lost', 'memory', 'MCP server', 'agent memory', 'persistent memory', 'session context', 'project context', 'recall', 'remember'…

not rated 12 20d ago A SkillSpector: warn 157 tokens original

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…

not rated 12 3mo ago A 115 tokens original MIT

dba

31

u1pns/skill-dba

Skill Claude CodeCodex

Use when working with relational databases (MySQL, PostgreSQL, SQL Server, Oracle, SQLite): auditing SQL/schemas, designing or normalizing schemas, optimizing slow queries and SARGability, data integrity (constraints/triggers), zero-downtime migrations and schema refactors, or routine DB maintenance and CLI ops.…

not rated 12 +1 4mo ago A 101 tokens

supabase-security

32

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…

not rated 11 6mo ago A 76 tokens

paradedb-skill

33

paradedb/agent-skills

Skill Claude CodeCodex

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

not rated 11 changed 14d ago A 65 tokens original MIT

postgram

34

ivo-toby/postgram

Skill Claude CodeCodex

Use the pgm CLI (Postgram) to persist, search, and link knowledge across sessions. Invoke whenever the user wants to remember something across conversations, recall prior context, search their personal knowledge base, track tasks, or explore relationships between stored entities. Assumes pgm is on PATH, PGMAPIURL is…

not rated 10 changed 7d ago A 112 tokens AGPL-3.0

rls-patterns

35

bybren-llc/a-safe-pulse

Skill Claude CodeCodex

Row Level Security patterns for database operations. Use when writing any database query, creating API routes that access data, implementing webhooks that write to the database, or working with user data. This project uses direct pg (node-postgres) queries with raw SQL -- no ORM.

not rated 9 6mo ago A 60 tokens original MIT

sqlike

36

orifisher2/sqlike

Skill Claude CodeCodex

Check SQL with sqlike — deterministic static analysis (validity, anti-patterns, rewrites, index advice) and query-equivalence verification. Use whenever you write, edit, review, or rewrite a SQL query, or need to prove two queries return the same results. Requires the sqlike MCP server (@sqlike/mcp) or the sqlike CLI…

not rated 7 changed 11d ago A 81 tokens original Apache-2.0

connectors

37

pretensor-ai/pretensor

Skill Claude CodeCodex

PostgreSQL connector and inspect() live in this package; graph product routing: SKILL.md.

not rated 5 1mo ago A 0 tokens original MIT

lead-listing-agent

38

Xcaffrey13/lead-listing-agent

Skill Claude CodeCodex

Upload CSV lead lists (AI Ark, Prospeo, Store Leads) to Neon Postgres, clean company names, enrich sales reps via AI Ark API, scrape company websites, AI-powered website analysis (competitors, ICP, descriptions, pricing, categorization) via Workers AI, custom enrichment, ICP scoring. Triggers on: upload leads, lead…

not rated 5 6mo ago A 126 tokens original MIT

memx

39

pgalilea/memx

Skill Claude CodeCodex

Skill "memx" from pgalilea/memx, covering memx, general guidelines, sqliteengine, postgresengine and mongodbengine.

not rated 5 19d ago A 33 tokens original MIT

backend-setup-stack

40

WESTsyre21/setup-backend-stack

Skill Claude CodeCodex

Bootstraps a local Node.js backend development stack with Docker, PostgreSQL, and an ORM (Prisma or Sequelize). Use this skill whenever the user wants to: initialize a new backend project, set up a Dockerized database locally, wire up an ORM with automated migrations, scaffold an Express server with a health endpoint…

not rated 4 4mo ago A 155 tokens original MIT

quarry

41

yiminspace/quarry

Skill Claude CodeCodex

Query PostgreSQL, MySQL, Redis and Neptune with Quarry (qy), compare data across environments, maintain reusable queries, and manage connections or the database workbench. Use for database evidence or explicit Quarry tasks, not general database design discussions.

not rated 4 2d ago A 51 tokens original MIT

pgmi

42

vvka-141/pgmi

Skill Claude CodeCodex

Use when working in a pgmi project — a directory containing deploy.sql and/or pgmi.yaml. pgmi is a PostgreSQL-native deployment driver that loads SQL files into pgtemp views and runs deploy.sql; deployment behavior lives in SQL, not CLI flags. Covers the execution model, basic-vs-advanced templates, transactional…

not rated 4 26d ago A 100 tokens

dbcli

43

Luckymingxuan/dbcli

Skill Codex

Use this skill when the user needs to inspect PostgreSQL tables, understand relationships, and execute SQL through dbcli.

not rated 3 5mo ago A 26 tokens original MIT

stack-knowledge

44

zachjxyz/jvn

Skill Claude Code

Project technology stack patterns for FastAPI + PostgreSQL + SQLAlchemy + Alembic + PyTorch + pandas.

not rated 2 7mo ago A 26 tokens original MIT

dbq

45

yinpengfei/skills

Skill Claude CodeCodex

A SQL assistant for querying MySQL, PostgreSQL, SQLite, and MariaDB databases across development, test, and production environments. SQL is the language used to read and change data in relational databases.

not rated 2 1mo ago A 76 tokens

postgresql

46

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.

not rated 2 9mo ago A 40 tokens

rls-policy

47

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.

not rated 2 4mo ago A 46 tokens original MIT

postgres-rag-skill

48

wjcwjc77/agentic-postgres-rag

Skill Claude CodeCodex

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

not rated 2 11mo ago A 32 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: