Database

PostgreSQL agent skills for Claude Code, Codex and other agents.

Open-source object-relational database known for reliability, extensibility and standards-compliant SQL.
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

PostgreSQL skills, ranked
#SkillRepositoryStarsUsed inTokensAuto-checkLicenceUpdated
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/agent-skills2.7k24 repos~808Automated safety check: PassMIT5 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/agent-skills2.7k3 repos~3.6kAutomated safety check: PassMIT5 days ago
3

Write, review, and migrate Supabase logs queries against the ClickHouse-backed logs table (the logs.all.otel analytics endpoint).

supabase/supabase111k—~2.4kAutomated safety check: PassApache-2.0today
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/supabase111k—~4.2kAutomated safety check: PassApache-2.0today
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/airbyte22k—~2.5kAutomated safety check: PassUnknowntoday
6

Indexes reference files on Postgres schema design, indexing, partitioning, query patterns, MVCC and VACUUM, and PlanetScale-specific operations.

planetscale/database-skills7053 repos~1.8kAutomated safety check: PassMITtoday
7
7.New LintOfficial

Create a new splinter lint — a SQL view that checks for a database anti-pattern.

supabase/splinter280—~2.9kAutomated safety check: NotesNo licence8 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/airbyte22k—~1.9kAutomated safety check: PassUnknowntoday
9
9.Neon AuthOfficial

Add authentication to a new app. An agent skill from neondatabase/agent-skills.

neondatabase/agent-skills100—~3.1kAutomated safety check: PassApache-2.0yesterday
10
10.Code ReviewOfficial

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/langchain-azure147—~2.3kAutomated safety check: PassMITtoday
11
11.Neon PostgresOfficial

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/agent-skills100—~4.1kAutomated safety check: NotesApache-2.0yesterday
12

Guidance for Neki, PlanetScale's distributed (sharded) Postgres. Load when working with a Neki database — connecting, data topology and shard keys…

planetscale/database-skills705—~2.1kAutomated safety check: PassMITtoday
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/orm48k—~3.8kAutomated safety check: NotesApache-2.0today
14
14.NeonOfficial

Overview of Neon, a complete set of cloud backend primitives around Lakebase Postgres: Auth, Object Storage, Functions, and the AI Gateway.

neondatabase/agent-skills100—~8.7kAutomated safety check: NotesApache-2.0yesterday
15

Generate, explain, edit, and fix Azure Cosmos DB for NoSQL (SQL API) queries.

microsoft/vscode-cosmosdb200—~4kAutomated safety check: WarnMITtoday
16

INVOKE THIS SKILL when your LangGraph needs to persist state, remember conversations, travel through history, or configure subgraph checkpointer scoping.

langchain-ai/langchain-skills1.3k1 repo~4.6kAutomated safety check: PassMIT2 days ago
17

Azure Cosmos DB performance optimization and best practices guidelines for NoSQL, partitioning, queries, and SDK usage.

microsoft/vscode-cosmosdb200—~4.3kAutomated safety check: PassMITtoday
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/orm48k—~5.7kAutomated safety check: PassApache-2.0today
19

S3-compatible object storage that branches with your Neon project, so files and the database stay in sync across every branch.

neondatabase/agent-skills100—~3.5kAutomated safety check: NotesApache-2.0yesterday
20

Azure PostgreSQL Flexible Server SDK for .NET. An agent skill from microsoft/skills.

microsoft/skills3.1k6 repos~4kAutomated safety check: PassMITyesterday
21

Connect to Azure Database for PostgreSQL Flexible Server from Node.js/TypeScript using the pg (node-postgres) package.

microsoft/skills3.1k5 repos~3.3kAutomated safety check: PassMITyesterday
22

Diagnose and fix excessive Postgres egress (network data transfer) in a codebase.

neondatabase/agent-skills100—~2.6kAutomated safety check: PassApache-2.0yesterday
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/awesome-copilot40k1 repo~798Automated safety check: PassMITtoday
24
24.Aurora DsqlOfficial

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/agent-toolkit-for-aws2.8k—~9.6kAutomated safety check: PassApache-2.0today
25

Inspect an application repository connected to PlanetScale and recommend SQLCommenter-compatible query tagging packages and conventions.

planetscale/skills133—~1.2kAutomated safety check: PassMITtoday
26

PostgreSQL-specific code review assistant focusing on PostgreSQL best practices, anti-patterns, and unique quality standards.

github/awesome-copilot40k2 repos~1.8kAutomated safety check: PassMITtoday
27

PostgreSQL-specific development assistant focusing on unique PostgreSQL features, advanced data types, and PostgreSQL-exclusive capabilities.

github/awesome-copilot40k2 repos~2.8kAutomated safety check: PassMITtoday
28
28.SQL OptimizationOfficial

Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server…

github/awesome-copilot40k2 repos~2.3kAutomated safety check: PassMITtoday
29

Creates an integration testing plan for .NET data access artifacts during Oracle-to-PostgreSQL database migrations.

github/awesome-copilot40k1 repo~669Automated safety check: PassMITtoday
30

Creates structured bug reports for defects found during Oracle-to-PostgreSQL migration.

github/awesome-copilot40k1 repo~616Automated safety check: PassMITtoday
31

Databricks Lakebase Postgres: projects, scaling, connectivity, Lakebase synced tables, and Data API.

databricks/databricks-agent-skills345—~5kAutomated safety check: PassUnknowntoday
32

Discovers all projects in a .NET solution, classifies each for Oracle-to-PostgreSQL migration eligibility, and produces a persistent master migration plan.

github/awesome-copilot40k1 repo~862Automated safety check: PassMITtoday
33

Create Spring Boot Java Project Skeleton. An agent skill from github/awesome-copilot.

github/awesome-copilot40k1 repo~1.1kAutomated safety check: PassMITtoday
34

Create Spring Boot Kotlin Project Skeleton. An agent skill from github/awesome-copilot.

github/awesome-copilot40k1 repo~1kAutomated safety check: PassMITtoday
35
35.SQL Code ReviewOfficial

Universal SQL code review assistant that performs comprehensive security, maintainability, and code quality analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle).

github/awesome-copilot40k1 repo~2.2kAutomated safety check: PassMITtoday
36

Guide for adding a new RPC to personhog-replica and personhog-router.

PostHog/posthog40k—~2.1kAutomated safety check: PassUnknowntoday
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/posthog40k—~2.9kAutomated safety check: PassUnknowntoday
38

Guides safe changes to the TaxonomicFilter, PostHog's picker for events, actions, properties, cohorts, and more.

PostHog/posthog40k—~2.8kAutomated safety check: PassUnknowntoday
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/posthog40k—~2.3kAutomated safety check: PassUnknowntoday
40

Create and troubleshoot AWS Glue connections to JDBC databases (Oracle, SQL Server, PostgreSQL, MySQL, RDS), Redshift, Snowflake, and BigQuery.

aws/agent-toolkit-for-aws2.8k1 repo~2.2kAutomated safety check: PassApache-2.0today
41

Generate D2 database diagrams from Entity Framework Core models.

github/awesome-copilot40k—~2.3kAutomated safety check: PassMITtoday
42
42.Alloydb BasicsOfficial

Manages clusters, instances, and backups for AlloyDB for PostgreSQL, and integrates with AlloyDB Model Context Protocol (MCP) tools for automated database operations.

google/skills21k—~1.7kAutomated safety check: PassApache-2.0today
43
43.Cloud SQL BasicsOfficial

This file generates or explains Cloud SQL resources. An agent skill from google/skills.

google/skills21k—~973Automated safety check: PassApache-2.0today
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/posthog40k—~1kAutomated safety check: PassUnknowntoday
45

Django migration patterns and safety workflow for PostHog. An agent skill from PostHog/posthog.

PostHog/posthog40k—~5kAutomated safety check: PassUnknowntoday
46

Run read-only SQL against the local Postgres app database (SELECT, EXPLAIN, EXPLAIN ANALYZE on SELECT).

PostHog/posthog40k—~2.5kAutomated safety check: NotesUnknowntoday
47

Runs read-only production database analysis through PostHog's internal Metabase instances.

PostHog/posthog40k—~2.8kAutomated safety check: PassUnknowntoday
48

Migrates .NET/C data access code from Oracle to PostgreSQL (Npgsql).

github/awesome-copilot40k—~2kAutomated safety check: PassMITtoday

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.