Database
PostgreSQL agent skills for Claude Code, Codex and other agents.
- skills
- 638
- official
- 69
- Type
- Database
- Website
- postgresql.org
- Official GitHub
- postgres
- Reviews
- See PostgreSQL on Enlisted
PostgreSQL skills, ranked
Ranked by score. Sort bymost stars,trending,newest,recently updated
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 1 | Gives the agent Postgres rules to consult before writing or changing tables, queries, indexes, RLS policies or migrations, and when diagnosing slow queries. | supabase/ | 2.7k | 24 repos | ~808 | Automated safety check: Pass | MIT | 5 days ago |
| 2 | General Supabase skill for database, auth, Edge Functions, Realtime and storage work, plus client libraries, migrations, security audits, debugging and reading logs. | supabase/ | 2.7k | 3 repos | ~3.6k | Automated safety check: Pass | MIT | 5 days ago |
| 3 | Write, review, and migrate Supabase logs queries against the ClickHouse-backed logs table (the logs.all.otel analytics endpoint). | supabase/ | 111k | — | ~2.4k | Automated safety check: Pass | Apache-2.0 | today |
| 4 | A skill your agent uses whenever code will build, return, fetch, or execute SQL that runs against a user's real Postgres database — even when the request reads like an ordinary feature or bug fix… | supabase/ | 111k | — | ~4.2k | Automated safety check: Pass | Apache-2.0 | today |
| 5 | Starts a local PostgreSQL 16 container, loads SQL fixtures and runs the Airbyte spec, check, discover and read commands against a chosen source-postgres image. | airbytehq/ | 22k | — | ~2.5k | Automated safety check: Pass | Unknown | today |
| 6 | Indexes reference files on Postgres schema design, indexing, partitioning, query patterns, MVCC and VACUUM, and PlanetScale-specific operations. | planetscale/ | 705 | 3 repos | ~1.8k | Automated safety check: Pass | MIT | today |
| 7 | Create a new splinter lint — a SQL view that checks for a database anti-pattern. | supabase/ | 280 | — | ~2.9k | Automated safety check: Notes | No licence | 8 days ago |
| 8 | Reproduces PostgreSQL logical-decoding CDC behavior for Airbyte's source-postgres connector on a local backend, with CDC fixtures, a catalog and smoke case scripts. | airbytehq/ | 22k | — | ~1.9k | Automated safety check: Pass | Unknown | today |
| 9 | Add authentication to a new app. An agent skill from neondatabase/agent-skills. | neondatabase/ | 100 | — | ~3.1k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 10 | Reviews changes in the langchain-azure monorepo using package-specific knowledge of langchain-azure-ai, langchain-azure-compute, langchain-azure-cosmosdb, langchain-azure-postgresql… | langchain-ai/ | 147 | — | ~2.3k | Automated safety check: Pass | MIT | today |
| 11 | Guides and best practices for working with Lakebase Postgres on Neon: connections, pooled vs direct, schema migrations, branching, autoscaling, scale-to-zero, instant restore, read replicas, IP… | neondatabase/ | 100 | — | ~4.1k | Automated safety check: Notes | Apache-2.0 | yesterday |
| 12 | Guidance for Neki, PlanetScale's distributed (sharded) Postgres. Load when working with a Neki database — connecting, data topology and shard keys… | planetscale/ | 705 | — | ~2.1k | Automated safety check: Pass | MIT | today |
| 13 | Routes Prisma 8 tasks such as contracts, migrations, queries and upgrades to the right reference files for projects on the contract-first @prisma/orm packages. | prisma/ | 48k | — | ~3.8k | Automated safety check: Notes | Apache-2.0 | today |
| 14 | Overview of Neon, a complete set of cloud backend primitives around Lakebase Postgres: Auth, Object Storage, Functions, and the AI Gateway. | neondatabase/ | 100 | — | ~8.7k | Automated safety check: Notes | Apache-2.0 | yesterday |
| 15 | Generate, explain, edit, and fix Azure Cosmos DB for NoSQL (SQL API) queries. | microsoft/ | 200 | — | ~4k | Automated safety check: Warn | MIT | today |
| 16 | INVOKE THIS SKILL when your LangGraph needs to persist state, remember conversations, travel through history, or configure subgraph checkpointer scoping. | langchain-ai/ | 1.3k | 1 repo | ~4.6k | Automated safety check: Pass | MIT | 2 days ago |
| 17 | Azure Cosmos DB performance optimization and best practices guidelines for NoSQL, partitioning, queries, and SDK usage. | microsoft/ | 200 | — | ~4.3k | Automated safety check: Pass | MIT | today |
| 18 | Captures friction a consumer of Prisma 8, Prisma Compute or Prisma Postgres would hit, logging it and filing a ticket instead of letting the lesson evaporate. | prisma/ | 48k | — | ~5.7k | Automated safety check: Pass | Apache-2.0 | today |
| 19 | S3-compatible object storage that branches with your Neon project, so files and the database stay in sync across every branch. | neondatabase/ | 100 | — | ~3.5k | Automated safety check: Notes | Apache-2.0 | yesterday |
| 20 | Azure PostgreSQL Flexible Server SDK for .NET. An agent skill from microsoft/skills. | microsoft/ | 3.1k | 6 repos | ~4k | Automated safety check: Pass | MIT | yesterday |
| 21 | Connect to Azure Database for PostgreSQL Flexible Server from Node.js/TypeScript using the pg (node-postgres) package. | microsoft/ | 3.1k | 5 repos | ~3.3k | Automated safety check: Pass | MIT | yesterday |
| 22 | Diagnose and fix excessive Postgres egress (network data transfer) in a codebase. | neondatabase/ | 100 | — | ~2.6k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 23 | Identifies Oracle-to-PostgreSQL migration risks by cross-referencing code against known behavioral differences (empty strings, refcursors, type coercion, sorting/collations, UNION ALL planner risks… | github/ | 40k | 1 repo | ~798 | Automated safety check: Pass | MIT | today |
| 24 | Provisions and manages Aurora DSQL clusters, connects via psql or DSQL Connectors, manages schemas, runs queries, migrates from MySQL, diagnoses query plans, and develops apps on serverless… | aws/ | 2.8k | — | ~9.6k | Automated safety check: Pass | Apache-2.0 | today |
| 25 | Inspect an application repository connected to PlanetScale and recommend SQLCommenter-compatible query tagging packages and conventions. | planetscale/ | 133 | — | ~1.2k | Automated safety check: Pass | MIT | today |
| 26 | PostgreSQL-specific code review assistant focusing on PostgreSQL best practices, anti-patterns, and unique quality standards. | github/ | 40k | 2 repos | ~1.8k | Automated safety check: Pass | MIT | today |
| 27 | PostgreSQL-specific development assistant focusing on unique PostgreSQL features, advanced data types, and PostgreSQL-exclusive capabilities. | github/ | 40k | 2 repos | ~2.8k | Automated safety check: Pass | MIT | today |
| 28 | Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server… | github/ | 40k | 2 repos | ~2.3k | Automated safety check: Pass | MIT | today |
| 29 | Creates an integration testing plan for .NET data access artifacts during Oracle-to-PostgreSQL database migrations. | github/ | 40k | 1 repo | ~669 | Automated safety check: Pass | MIT | today |
| 30 | Creates structured bug reports for defects found during Oracle-to-PostgreSQL migration. | github/ | 40k | 1 repo | ~616 | Automated safety check: Pass | MIT | today |
| 31 | Databricks Lakebase Postgres: projects, scaling, connectivity, Lakebase synced tables, and Data API. | databricks/ | 345 | — | ~5k | Automated safety check: Pass | Unknown | today |
| 32 | Discovers all projects in a .NET solution, classifies each for Oracle-to-PostgreSQL migration eligibility, and produces a persistent master migration plan. | github/ | 40k | 1 repo | ~862 | Automated safety check: Pass | MIT | today |
| 33 | Create Spring Boot Java Project Skeleton. An agent skill from github/awesome-copilot. | github/ | 40k | 1 repo | ~1.1k | Automated safety check: Pass | MIT | today |
| 34 | Create Spring Boot Kotlin Project Skeleton. An agent skill from github/awesome-copilot. | github/ | 40k | 1 repo | ~1k | Automated safety check: Pass | MIT | today |
| 35 | Universal SQL code review assistant that performs comprehensive security, maintainability, and code quality analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). | github/ | 40k | 1 repo | ~2.2k | Automated safety check: Pass | MIT | today |
| 36 | Guide for adding a new RPC to personhog-replica and personhog-router. | PostHog/ | 40k | — | ~2.1k | Automated safety check: Pass | Unknown | today |
| 37 | Sync columns from a synced data warehouse table onto PostHog person or group properties, so warehouse data becomes usable anywhere person and group properties already work: feature flag targeting… | PostHog/ | 40k | — | ~2.9k | Automated safety check: Pass | Unknown | today |
| 38 | Guides safe changes to the TaxonomicFilter, PostHog's picker for events, actions, properties, cohorts, and more. | PostHog/ | 40k | — | ~2.8k | Automated safety check: Pass | Unknown | today |
| 39 | Set up the local dev environment, seed data, and API keys to test the staff-only managed migrations MCP tools (managed-migrations-support-list, managed-migrations-support-get) end to end. | PostHog/ | 40k | — | ~2.3k | Automated safety check: Pass | Unknown | today |
| 40 | Create and troubleshoot AWS Glue connections to JDBC databases (Oracle, SQL Server, PostgreSQL, MySQL, RDS), Redshift, Snowflake, and BigQuery. | aws/ | 2.8k | 1 repo | ~2.2k | Automated safety check: Pass | Apache-2.0 | today |
| 41 | Generate D2 database diagrams from Entity Framework Core models. | github/ | 40k | — | ~2.3k | Automated safety check: Pass | MIT | today |
| 42 | Manages clusters, instances, and backups for AlloyDB for PostgreSQL, and integrates with AlloyDB Model Context Protocol (MCP) tools for automated database operations. | google/ | 21k | — | ~1.7k | Automated safety check: Pass | Apache-2.0 | today |
| 43 | This file generates or explains Cloud SQL resources. An agent skill from google/skills. | google/ | 21k | — | ~973 | Automated safety check: Pass | Apache-2.0 | today |
| 44 | Analyze PostHog insights, dashboards, or teams beyond the current project by querying the prod Postgres replicas synced into the dogfood data warehouse (US project 2, "PostHog App + Website"). | PostHog/ | 40k | — | ~1k | Automated safety check: Pass | Unknown | today |
| 45 | Django migration patterns and safety workflow for PostHog. An agent skill from PostHog/posthog. | PostHog/ | 40k | — | ~5k | Automated safety check: Pass | Unknown | today |
| 46 | Run read-only SQL against the local Postgres app database (SELECT, EXPLAIN, EXPLAIN ANALYZE on SELECT). | PostHog/ | 40k | — | ~2.5k | Automated safety check: Notes | Unknown | today |
| 47 | Runs read-only production database analysis through PostHog's internal Metabase instances. | PostHog/ | 40k | — | ~2.8k | Automated safety check: Pass | Unknown | today |
| 48 | Migrates .NET/C data access code from Oracle to PostgreSQL (Npgsql). | github/ | 40k | — | ~2k | Automated safety check: Pass | MIT | today |
Questions, answered from the data.
What is the best PostgreSQL skill?
Supabase Postgres Best Practices (official) from supabase/agent-skills ranks first of the 638 PostgreSQL skills listed here, with the highest score: its repository has 2.7k GitHub stars, 24 other GitHub owners carry a copy, its SKILL.md loads about 808 tokens and it passes the automated safety check with no findings. Next come Supabase Development and Debugging and Clickhouse Logs Queries.
Is there an official PostgreSQL skill?
69 of the 638 PostgreSQL skills are official, published by the vendor's own GitHub organization: Supabase Postgres Best Practices, Supabase Development and Debugging, Clickhouse Logs Queries, Safe SQL Execution, Airbyte Postgres Source E2E Tests and 64 more.
How are these skills ranked?
By Skill Navigator score, which combines the GitHub stars of the skill's repository (shared across that repo's skills and discounted for large collections), how many other GitHub owners carry a copy of the skill, and automated SKILL.md quality checks, minus penalties for safety-check warnings and for each further skill from the same repository. Skills that fail the safety check are not listed.