Skills real projects publish on GitHub, most starred first. Each one says what it will make an agent do before you copy it.
kumaran-isSkillkumaran-is/claude-code-onboarding/.claude/skills/postgresql/SKILL.md
PostgreSQL-specific schema design reference for advanced data types (ENUM, array, range, network, domain), storage internals (MVCC, HOT updates, TOAST, heap), and advanced constraints (EXCLUDE, generated columns). Use when designing PostgreSQL schemas, choosing data types, working with extensions (pgvector, PostGIS, TimescaleDB), or handling schema evolution safely without downtime.
hkarpinenSkillhkarpinen/agent-skills/db-postgres/SKILL.md
PostgreSQL schema design conventions — how to translate domain models into PostgreSQL idioms. Use when designing or reviewing a PostgreSQL database schema, choosing data types, defining indexes, constraints, schema separation, full-text search with tsvector/tsquery, or modeling hierarchical/tree-structured data (nested comments, categories). Stack and ORM agnostic — applies regardless of the application stack.
robconerySkillrobconery/kolea/.claude/skills/postgres-dba/SKILL.md
Opinionated PostgreSQL schema and database design conventions: snake_case naming, `id serial primary key` surrogate keys, compound primary keys for many-to-many junctions, NOT NULL foreign keys by default (nullable only with an explicit override), enums instead of excessive lookup tables, STORED generated columns for derived/searchable data, business logic in plpgsql functions instead of application code, and JSONB used as a document store alongside a relational spine. Use when designing or reviewing a Postgres schema, writing DDL/migrations, naming tables/columns/constraints, deciding enum vs lookup table, modeling many-to-many, choosing JSONB vs columns, or answering "what is the right Postgres way to do this" questions. Ships copy-ready DDL, function, and JSONB-document templates.
AojdevStudioSkillAojdevStudio/development-kit/.claude/skills/postgres-pro/SKILL.md
Use when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features. Invoke for EXPLAIN analysis, JSONB operations, extension usage, VACUUM tuning, performance monitoring.
trodixSkilltrodix/claude-skills/postgres-pro/SKILL.md
Use when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features. Invoke for EXPLAIN analysis, JSONB operations, extension usage, VACUUM tuning, performance monitoring.
usmanmubarak1Skillusmanmubarak1/ClaudeSkilledAgents/skills/postgres-pro/SKILL.md
Use when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features. Invoke for EXPLAIN analysis, JSONB operations, extension usage, VACUUM tuning, performance monitoring.
atherio-danpSkillatherio-danp/cde-dotnetcc/.claude/skills/query-postgres/SKILL.md
Run read-only SQL against the {{ProductName}} PostgreSQL database to investigate or verify data during diagnosis. Use when asked to query the database directly or check actual data behind an issue. Preloaded by the rca-investigator agent.
joshpriceSkilljoshprice/claude-skills-from-usage-rules/.claude/skills/ash-postgres/SKILL.md
Rules for working with AshPostgres
ai4brands-designSkillai4brands-design/claude-skills/mcp-postgres/SKILL.md
Interact with PostgreSQL databases.
conjure-3301Skillconjure-3301/skills/postgrest/SKILL.md
PostgREST attack surface: row-level security gaps, JWT secret leak, schema introspection
LeonardoTrapaniSkillLeonardoTrapani/better-skills/.agents/skills/neon-postgres/SKILL.md
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 questions.
KunanonJSkillKunanonJ/ai-skills-hub/.agents/skills/postgresql/SKILL.md
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
andreab67Skillandreab67/agent-skills/postgres-ops/SKILL.md
Operational PostgreSQL workflows for production - diagnosing slow queries, lock contention, bloat, replication lag, and connection-pool exhaustion; designing and reviewing backups and PITR; planning upgrades and major-version migrations; configuring pgBouncer, RDS Proxy, or PgCat; tuning postgresql.conf for OLTP and analytics; reviewing schema migrations (EF Core, Alembic, Flyway, raw SQL); observability with postgres_exporter, Loki, and slow-query alerting; DoD/federal hardening (STIG, role separation, RLS, pgaudit, TLS). Use whenever the user mentions Postgres, PostgreSQL, pg_, EXPLAIN ANALYZE, autovacuum, pgBouncer, replication lag, or schema migrations, or describes a Postgres incident, performance problem, upgrade, backup, or compliance audit - even without saying Postgres when the context is clearly PostgreSQL. Do NOT use for greenfield CRUD scaffolding (a separate app-scaffolding skill, not in this catalog).
irahardiantoSkillirahardianto/awesome-agv/.agents/skills/postgres-idioms/SKILL.md
PostgreSQL best practices — schema design, query performance, indexing, connection management, RLS, concurrency, monitoring, and migrations. Load when writing SQL, designing schemas, or optimizing PostgreSQL queries.
ai4brands-designSkillai4brands-design/claude-skills/postgresql/SKILL.md
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
bcastelinoSkillbcastelino/agent-skills-kit/skills/postgresql/SKILL.md
Design PostgreSQL-specific schemas covering best practices, data types, indexing, constraints, performance patterns, and advanced features. Use when designing or optimizing PostgreSQL databases.
ffsshhttiikkSkillffsshhttiikk/opencode-agents-skills/postgresql/SKILL.md
PostgreSQL advanced open-source relational database
Sorcha-PlatformSkillSorcha-Platform/Sorcha/.claude/skills/postgresql/SKILL.md
Manages PostgreSQL databases and Entity Framework Core integration. Use when: configuring database connections, writing migrations, creating DbContext classes, optimizing queries, or integrating with .NET Aspire.
SamarthPyatiSkillSamarthPyati/Open-Source-Scout/.agents/skills/neon-postgres/SKILL.md
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 questions.
jornalistainclusivoSkilljornalistainclusivo/jinc-skills/.agents/skills/postgresql/SKILL.md
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
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.
