Skills real projects publish on GitHub, most starred first. Each one says what it will make an agent do before you copy it.
ai4brands-designSkillai4brands-design/claude-skills/neon-postgres/SKILL.md
Expert patterns for Neon serverless Postgres, branching, connection pooling, and Prisma/Drizzle integration Use when: neon database, serverless postgres, database branching, neon postgres, postgres serverless.
AribSudiaSkillAribSudia/claude-code-methodology/.claude/skills/arib-postgres/SKILL.md
Stack | PostgreSQL optimization & safety patterns — indexing, query plans, N+1, safe online migrations, connection pooling, JSONB, and Row-Level Security for multi-tenancy. Use when designing or reviewing Postgres-backed data access. Composes with database-guardian (migration safety) and performance (query budgets). Authored natively (MIT), not an ECC copy.
loulanyueSkillloulanyue/awesome-claude-notes/skills/postgres-patterns/SKILL.md
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.
Tyler-R-KendrickSkillTyler-R-Kendrick/agent-skills/.agents/skills/azure-postgres/SKILL.md
Create new Azure Database for PostgreSQL Flexible Server instances and configure passwordless authentication with Microsoft Entra ID. Set up developer access, managed identities for apps, group-based permissions, and migrate from password-based to Entra ID authentication. Trigger phrases include "passwordless for postgres", "entra id postgres", "azure ad postgres authentication", "postgres managed identity", "migrate postgres to passwordless".
anurag-azureSkillanurag-azure/skills/postgresql/SKILL.md
PostgreSQL design and usage: schema design, indexing, constraints, transactions/isolation, JSONB, and connection pooling.
tranhieuttSkilltranhieutt/software_development_department/.claude/skills/postgres-patterns/SKILL.md
name: postgres-patterns type: reference description: "Provides PostgreSQL patterns for query optimization, schema design, indexing strategies, RLS, and security. Use when working with PostgreSQL SQL files or when the user
ccheneySkillccheney/robust-skills/skills/postgres-drizzle/SKILL.md
Write or review PostgreSQL schemas, queries, migrations, and Drizzle ORM code. Use for Postgres/Drizzle relations, indexing, pooling, or query performance; not for unrelated databases or generic backend work.
vobaseSkillvobase/vobase/.claude/skills/postgres-drizzle/SKILL.md
Proactively apply when creating APIs, backends, or data models. Triggers on PostgreSQL, Postgres, Drizzle, database, schema, tables, columns, indexes, queries, migrations, ORM, relations, joins, transactions, SQL, drizzle-kit, connection pooling, N+1, JSONB, RLS. Use when writing database schemas, queries, migrations, or any database-related code. PostgreSQL and Drizzle ORM best practices.
roomkit-liveSkillroomkit-live/roomkit-skills/setup-postgres/SKILL.md
Configure PostgresStore for production RoomKit deployments with connection pooling, schema migration, and telemetry integration. Use when the user wants to persist rooms and events in PostgreSQL, migrate from InMemoryStore, or set up production storage.
AWSSkillawslabs/mcp/src/aurora-dsql-mcp-server/skills/distributed-postgres-skill/SKILL.md
Deprecated compatibility redirect for Aurora DSQL guidance. Use when a request concerns DSQL, Aurora DSQL, distributed SQL, DSQL schemas, migrations, queries, authentication, performance, or application development.
0xMassiSkill0xMassi/claude-skills/postgres-strict/SKILL.md
PostgreSQL strictness, schema design, indexing, migration safety, and operational rules. Use when designing schemas, writing queries, reviewing migrations, tuning performance, or hardening a Postgres deployment. Targets PostgreSQL 16-18, with notes on pgvector, partitioning, and RLS. Pairs with security-audit-standard and performance-audit-standard.
skatedduSkillskateddu/claude-code-python-setup/.claude/skills/postgres-patterns/SKILL.md
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.
cohen-lielSkillcohen-liel/hivemind/.claude/skills/postgres-database/SKILL.md
PostgreSQL schema design, indexing, and query patterns. Use when designing database schemas, writing migrations, optimizing queries, or working with any PostgreSQL database.
AIops-toolsSkillAIops-tools/Postgres-AIops/skills/postgres-aiops/SKILL.md
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 (pg_stat_statements top-N, EXPLAIN a statement); index health (unused indexes, missing-index hints, bloat, invalid/duplicate); table health (sizes, dead-tuple bloat, autovacuum status); replication (standby lag, replication slots, WAL); three flagship analyses — slow-query RCA (worst pg_stat_statements entry + EXPLAIN → cause/action), bloat & vacuum analysis (dead tuples + autovacuum lag → recommendation), and blocking lock-chain RCA (build the wait-for tree, name the root blocker); and guarded writes (terminate a backend, cancel a query, VACUUM/ANALYZE, create/drop an index, REINDEX, ALTER SYSTEM SET a parameter, reset query stats). Always use this skill for "postgres health check", "why is this query slow", "pg_stat_statements top queries", "EXPLAIN this", "table/index bloat", "which indexes are unused", "missing index", "autovacuum status", "who is blocking whom", "kill the backend holding the lock", "replication lag", "replication slots", "VACUUM this table", "create/drop an index", or "ALTER SYSTEM SET work_mem" when the context is a PostgreSQL database. Do NOT use when the target is OT / industrial equipment (Modbus, OPC-UA, PLCs — use industrial-aiops), a hypervisor, a storage appliance, a backup product, a container/cluster orchestrator, or a non-PostgreSQL database (negative routing hints only). Covers common PostgreSQL DBA operations with a built-in governance harness (audit, token budget, undo, risk-tiers). Beyond the mock suite, the reads plus a governed write and its undo have been exercised against a live PostgreSQL 16.14 instance (see docs/VERIFICATION.md).
Thanane15MSkillThanane15M/postgres-first/SKILL.md
Evaluates whether PostgreSQL can satisfy database, cache, queue, search, vector, background-job, pub/sub, rate-limit, audit, or multi-tenant requirements before adding another data service. Use when designing or simplifying backend architecture, reviewing Redis/MongoDB/Elasticsearch/vector-store usage, or planning a migration toward PostgreSQL-native patterns.
digoalSkilldigoal/skills/find-postgres-bug/SKILL.md
在给定的 PostgreSQL 源码目录中系统化挖掘尚未被社区报告的未知 bug（内存错误、并发/锁问题、优化器逻辑错误、边界溢出等），产出可复现、可提交给 PostgreSQL 官方安全邮件列表或 bug 表单的中文诊断报告。触发条件：用户提供了 PostgreSQL 源码目录路径，并提到\u201c找 PostgreSQL bug\u201d、\u201c挖掘数据库漏洞\u201d、\u201c找未知 bug\u201d、\u201cfuzz postgres\u201d、\u201c内核 bug 猎手\u201d、\u201c帮我审查这段 PG 源码有没有问题\u201d、\u201c这个提交安全吗\u201d、\u201c我要给社区提 bug\u201d、\u201cfind postgres bug\u201d、\u201cPG 源码找 bug\u201d，或希望对 PostgreSQL 源码做 sanitizer 构建、模糊测试、差分测试、并发压力测试、历史提交模式挖掘、新提交审查等任一环节。即使用户只说\u201c帮我看看这份 PG 代码有没有隐藏问题\u201d或\u201c我想给 PostgreSQL 社区贡献一个 bug 报告\u201d，只要涉及源码目录 + 挖掘未知缺陷，也应使用本 skill。本 skill 仅用于合法的开源安全研究与负责任披露，绝不用于攻击生产环境或未获授权的系统。
azlekovSkillazlekov/my-claude-code/skills/postgres-nanoid/SKILL.md
This skill should be used when the user asks to "generate IDs", "create identifiers", "use nanoid", "add public_id", "prefixed identifiers", "short IDs", or discusses ID generation strategies, public vs internal IDs, or URL-friendly identifiers. Use nanoid for public identifiers and UUID for auth.users references.
LukasbrujulaSkillLukasbrujula/claude-code-framework/.claude/skills/postgres-patterns/SKILL.md
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.
HiAi-ggSkillHiAi-gg/hiai-opencode/skills/build/supabase-postgres/SKILL.md
Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
timescaleSkilltimescale/pg-aiguide/skills/design-postgres-tables/SKILL.md
Use this skill for general PostgreSQL table design.
A folder with a SKILL.md file: a name, a description of when to use it, and instructions. Claude loads a skill only when the task matches its description.
Copy the folder into your project's .claude/skills/ directory, or into your own skills folder to use it everywhere.
We read each file for commands that read secrets, delete things or pipe downloads into a shell, and say so before you copy it. No warning is not a promise that a file is safe.
Open a skill to see its discussion. Reports from people and their agents are coming.
