MCP CheckClaude skills for Postgres
158 public Claude skills touch on Postgres. These 50 are the closest fit, best-known sources first. Each links to its folder; copy it into ~/.claude/skills/ to use it.
postgresql table design
Use this skill when designing or reviewing a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
wshobson/agents★ 42kMITFolder:
postgresql-table-designcreating oracle to postgres master migration plan
Discovers all projects in a .NET solution, classifies each for Oracle-to-PostgreSQL migration eligibility, and produces a persistent master migration plan. Use when starting a multi-project Oracle-to-PostgreSQL migration, creating a migration inventory, or…
github/awesome-copilot★ 41kMITFolder:
creating-oracle-to-postgres-master-migration-plancreating oracle to postgres migration integration tests
Creates integration test cases targeting Oracle for .NET data access artifacts. Tests capture Oracle expected behavior as the authoritative baseline; they are written once and later ported to PostgreSQL by migrating the test project in Phase 6. Use only…
github/awesome-copilot★ 41kMITFolder:
creating-oracle-to-postgres-migration-integration-testscreating oracle to postgres migration bug report
Creates structured bug reports for defects found during Oracle-to-PostgreSQL migration. Use when documenting behavioral differences between Oracle and PostgreSQL as actionable bug reports with severity, root cause, and remediation steps.
github/awesome-copilot★ 41kMITFolder:
creating-oracle-to-postgres-migration-bug-reportpostgres pro
Use when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features. Invoke for EXPLAIN analysis, JSONB operations, extension usage, VACUUM tuning, performance monitoring.
Jeffallan/claude-skills★ 12kMITFolder:
postgres-proazure resource manager postgresql dotnet
Azure PostgreSQL Flexible Server SDK for .NET. Database management for PostgreSQL Flexible Server deployments. Use for creating servers, databases, firewall rules, configurations, backups, and high availability. Triggers: "PostgreSQL",…
microsoft/skills★ 3.2kMITFolder:
azure-resource-manager-postgresql-dotnetazure postgres ts
Connect to Azure Database for PostgreSQL Flexible Server from Node.js/TypeScript using the pg (node-postgres) package. Use for PostgreSQL queries, connection pooling, transactions, and Microsoft Entra ID (passwordless) authentication. Triggers:…
microsoft/skills★ 3.2kMITFolder:
azure-postgres-tsmigrate postgres tables to hypertables
Use this skill to migrate identified PostgreSQL tables to Timescale/TimescaleDB hypertables with optimal configuration and validation.
timescale/pg-aiguide★ 1.9kApache-2.0Folder:
migrate-postgres-tables-to-hypertablespostgres
Use this skill for any PostgreSQL database work — table design, indexing, data types, constraints, extensions (pgvector, PostGIS, TimescaleDB), search, and migrations.
timescale/pg-aiguide★ 1.9kApache-2.0Folder:
postgrespostgres database migration
Use this skill for planning, testing, and safely executing PostgreSQL schema migrations — especially when working with production data or shared databases.
timescale/pg-aiguide★ 1.9kApache-2.0Folder:
postgres-database-migrationpostgresql planning
Plan and implement OpenMeld PostgreSQL business persistence, schemas and migrations, transactions, Hyperdrive access, and data cutover. Use for the shared relational database transition or PostgreSQL work; not for unrelated D1 performance fixes or…
amplifthq/openmeld★ 1.4kMITFolder:
postgresql-planningsupabase postgres best practices
Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill BEFORE writing or changing anything that lives in a Postgres database: creating or altering tables and columns (including choosing column types), schema design,…
fcakyon/claude-codex-settings★ 1.2kApache-2.0Folder:
supabase-postgres-best-practicespostgresql
Administer PostgreSQL databases. Configure replication, backups, and performance tuning. Use when managing PostgreSQL deployments.
BagelHole/DevOps-Security-Agent-Skills★ 1.2kMITFolder:
postgresqlpostgresql best practices cloudbase
CloudBase PostgreSQL access-pattern and slow-query quality guidance. Use when designing how tables are read and written, eliminating per-row database calls, adding indexes for filters or joins, reviewing high-traffic data access, or explaining a slow SQL…
TencentCloudBase/CloudBase-AI-Toolkit★ 1.2kMITFolder:
postgresql-best-practices-cloudbasepostgresql development cloudbase
Use when building, debugging, or evaluating CloudBase PostgreSQL / CloudBase PG / PG mode apps, including Postgres schema setup, queryPgDatabase/managePgDatabase, JS SDK v3 app.rdb() CRUD/RPC, PG HTTP API fallback, RLS-style permissions, username-password…
TencentCloudBase/CloudBase-AI-Toolkit★ 1.2kMITFolder:
postgresql-development-cloudbaseazure database postgresql
Expert knowledge for Azure Database for PostgreSQL development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when…
MicrosoftDocs/Agent-Skills★ 797CC-BY-4.0Folder:
azure-database-postgresqlpostgresql code review
PostgreSQL-specific code review assistant focusing on PostgreSQL best practices, anti-patterns, and unique quality standards. Covers JSONB operations, array usage, custom types, schema design, function optimization, and PostgreSQL-exclusive security…
syahiidkamil/Software-Engineer-AI-Agent-Atlas★ 404No licence statedFolder:
postgresql-code-reviewpostgresql optimization
PostgreSQL-specific development assistant focusing on unique PostgreSQL features, advanced data types, and PostgreSQL-exclusive capabilities. Covers JSONB operations, array types, custom types, range/geometric types, full-text search, window functions, and…
syahiidkamil/Software-Engineer-AI-Agent-Atlas★ 404No licence statedFolder:
postgresql-optimizationpostgres code review
Reviews PostgreSQL code for indexing strategies, JSONB operations, connection pooling, and transaction safety. Use when reviewing SQL queries, database schemas, JSONB usage, or connection management.
existential-birds/beagle★ 85Apache-2.0Folder:
postgres-code-reviewpostgres ops
PostgreSQL operations, optimization, and administration. Use for: schema design, index selection, query tuning with EXPLAIN ANALYZE, postgresql.conf configuration, backup and restore (pg_dump, pg_basebackup, WAL, PITR), vacuum and autovacuum tuning,…
0xDarkMatter/claude-mods★ 78MITFolder:
postgres-opsdotnet postgresql best practices
PostgreSQL database design best practices, naming conventions, indexing strategies, and performance optimization for .NET applications using Npgsql and EF Core.
ronnythedev/dotnet-clean-architecture-skills★ 77No licence statedFolder:
25.1-dotnet-postgresql-best-practicespostgres patterns
Provides PostgreSQL patterns for query optimization, schema design, indexing strategies, RLS, and security. Use when working with PostgreSQL SQL files or when the user mentions PostgreSQL, Postgres, pgvector, Supabase, or database optimization.
tranhieutt/software_development_department★ 74MITFolder:
postgres-patternsPostgreSQL Database
Development patterns with PostgreSQL via FireDAC — connection, PL/pgSQL, sequences, JSONB, UPSERT, full-text search, migrations
delphicleancode/delphi-spec-kit★ 57MITFolder:
postgresql-databaseneon postgres agent platforms
Build and operate multi-tenant AI agent platforms on Neon. Use this skill whenever the user is designing an agent/app builder, provisioning a Neon project or database per user/app/agent run, managing thousands of tenant projects, separating sponsored free…
georgekhananaev/claude-skills-vault★ 30MITFolder:
neon-postgres-agent-platformsapi database postgresql
Direct PostgreSQL access with node-postgres (pg) -- connection pools, parameterized queries, transactions, streaming, LISTEN/NOTIFY, error handling
agents-inc/skills★ 26MITFolder:
api-database-postgresqlapi database vercel postgres
Serverless PostgreSQL on Vercel with edge-compatible SDK
agents-inc/skills★ 26MITFolder:
api-database-vercel-postgrespostgres job queue
PostgreSQL-based job queue with priority scheduling, batch claiming, and progress tracking. Use when building job queues without external dependencies. Triggers on PostgreSQL job queue, background jobs, task queue, priority queue, SKIP LOCKED.
wpank/ai★ 12No licence statedFolder:
postgres-job-queuesupabase postgres
Postgres performance optimization and best practices from Supabase — covering indexing, connection management, RLS security, schema design, locking, data access patterns, and monitoring. Use when writing SQL, designing schemas, optimizing queries, or…
wpank/ai★ 12No licence statedFolder:
supabase-postgresfix slow queries
Diagnose and fix slow Paperclip PostgreSQL queries using Cloud and Neon evidence, local reproduction, performance and result comparisons, regression tests, and a PR with passing checks. Use for costly queries, repeated database work, or slow requests with…
paperclipai/paperclip★ 109kMITFolder:
fix-slow-queriescognee docker
Use when the user wants to run cognee with Docker or docker compose — trying it out from the prebuilt image, starting the API server in a container, or bringing up the full stack (UI, MCP, Postgres, Neo4j) with compose profiles.
topoteretes/cognee★ 33kApache-2.0Folder:
cognee-dockercognee integrations
Use when the user wants to connect cognee to external services — switching LLM or embedding providers (OpenAI, Azure, Gemini, Anthropic, Ollama, OpenRouter), changing databases (Postgres, PGVector, Neo4j, Neptune, Turso), S3 storage, or the MCP server for…
topoteretes/cognee★ 33kApache-2.0Folder:
cognee-integrationssql queries
Generate SQL queries from natural language descriptions. Supports BigQuery, PostgreSQL, MySQL, and other dialects. Reads database schemas from uploaded diagrams or documentation. Use when writing SQL, building data reports, exploring databases, or…
phuryn/pm-skills★ 28kMITFolder:
sql-queriesdatabase optimizer
Optimizes database queries and improves performance across PostgreSQL and MySQL systems. Use when investigating slow queries, analyzing execution plans, or optimizing database performance. Invoke for index design, query rewrites, configuration tuning,…
Jeffallan/claude-skills★ 12kMITFolder:
database-optimizeroffensive sqli
SQL injection testing skill for offensive security assessments and bug bounty hunting. Covers error-based, UNION-based, boolean/time-based blind, out-of-band, second-order, NoSQL, GraphQL, WebSocket, and JSON-operator SQLi. Includes WAF bypass techniques,…
SnailSploit/Claude-Red★ 9.8kMITFolder:
offensive-sqlimirrord db branching
Helps users configure mirrord.json for database branching, enabling isolated database copies for safe development and testing. Use when the user wants to set up MySQL, MariaDB, PostgreSQL, MSSQL, MongoDB, Redis, DynamoDB, ClickHouse, Google Spanner, Amazon…
metalbear-co/mirrord★ 5.4kMITFolder:
mirrord-db-branchingdatabase scout
Explore SQLite and PostgreSQL databases: list tables, inspect schemas (columns/types/constraints), preview data, generate Mermaid ER diagrams, and run safe read-only queries. Triggered by requests to explore a database, view table structures, describe…
zebbern/claude-code-guide★ 4.7kMITFolder:
database-scoutsql insight
Translate natural language to SQL, optimize query performance, and interpret EXPLAIN plans for SQLite and PostgreSQL. Triggered when users ask to convert questions into SQL, improve slow queries, tune indexes, analyze execution plans, or mention keywords…
zebbern/claude-code-guide★ 4.7kMITFolder:
sql-insightgolang database
Comprehensive guide for Go database access — parameterized queries, struct scanning, NULLable columns, transactions, isolation levels, SELECT FOR UPDATE, connection pool, batch processing, context propagation, and migration tooling. Use when writing,…
samber/cc-skills-golang★ 3.7kMITFolder:
golang-databasewiki export
Export the Obsidian wiki graph to JSON, GraphML, Neo4j Cypher, Postgres/SQL, HTML, or OKF bundles. Use when transferring or visualizing wiki data in external tools; wiki-import handles the reverse direction.
Ar9av/obsidian-wiki★ 3.6kMITFolder:
wiki-exportcohesivity
Backend infrastructure for a project via Cohesivity (cohesivity.ai). Provisions Postgres, Redis, object storage, vector database, hosting, auth, realtime, email inbox, and AI model APIs through one HTTP API. No account or API keys required to start.…
Anil-matcha/awesome-muse-connectors★ 1.4kMITFolder:
cohesivityneon
Inspect Neon serverless Postgres: projects, branches, databases. Branch create and delete need exact-match confirmation; connection passwords are masked. Trigger phrases: neon, serverless postgres, database branch, postgres project.
Anil-matcha/awesome-muse-connectors★ 1.4kMITFolder:
neonsupabase
Read and write a Supabase Postgres database over PostgREST: list tables, query, insert, update, and delete rows. Trigger phrases: supabase, supabase table, query supabase.
Anil-matcha/awesome-muse-connectors★ 1.4kMITFolder:
supabasestripe projects
Use when the user wants to provision infrastructure or third-party services using Stripe Projects. Triggers: "I need a database", "set up auth", "add caching", "give me a Postgres", "provision Redis", "I need hosting", "add a vector DB", "get me an API key…
fcakyon/claude-codex-settings★ 1.2kApache-2.0Folder:
stripe-projectsdatabase design
Database schema design, optimization, and migration patterns for PostgreSQL, MySQL, and NoSQL databases. Use for designing schemas, writing migrations, or optimizing queries.
MoizIbnYousaf/ai-agent-skills★ 1.2kMITFolder:
database-designcloudbase document database web sdk
Use CloudBase document database Web SDK only for confirmed NoSQL collection work. Query, create, update, and delete document data; if the task mentions PostgreSQL / CloudBase PG / app.rdb(), route to postgresql-development instead.
TencentCloudBase/CloudBase-AI-Toolkit★ 1.2kMITFolder:
cloudbase-document-database-web-sdkrelay 80 100 workflow
Use when writing agent-relay workflows that must fully validate features end-to-end before merging. Covers the 80-to-100 pattern - going beyond "code compiles" to "feature works, tested E2E locally." Includes repair-before-failure validation gates,…
AgentWorkforce/relay★ 1.1kApache-2.0Folder:
relay-80-100-workflowdatabase designer
Database design with schema analysis, index optimization, and migration generation for PostgreSQL, MySQL, MongoDB, and DynamoDB. Use when designing schemas, optimizing queries, planning migrations, or analyzing database performance.
borghei/Claude-Skills★ 1kLicence: see repoFolder:
database-designerdatabase schema designer
Design relational schemas from requirements with normalization, migrations, ERDs, RLS policies, and indexes for PostgreSQL, MySQL, and SQLite. Use when designing new features, reviewing schemas, or adding multi-tenancy.
borghei/Claude-Skills★ 1kLicence: see repoFolder:
database-schema-designersenior backend
Backend development with Node.js/Express/Fastify and PostgreSQL. Use when designing REST or GraphQL APIs, optimizing database queries, implementing authentication, building microservices, handling migrations, or reviewing backend code.
borghei/Claude-Skills★ 1kLicence: see repoFolder:
senior-backenddsql
Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, diagnose cluster performance, load data, and develop applications with a serverless, distributed SQL database. Covers IAM auth, multi-tenant patterns,…
awslabs/agent-plugins★ 932Apache-2.0Folder:
dsql
Claude skills for Postgres: what people ask
Is there a Claude skill for Postgres?
Yes: 158 public skills from 79 GitHub repositories mention Postgres. The best-known ones named for it are postgresql table design (wshobson/agents, ★ 42k), creating oracle to postgres master migration plan (github/awesome-copilot, ★ 41k) and creating oracle to postgres migration integration tests (github/awesome-copilot, ★ 41k). Stars belong to the whole repository, not to one skill.
How do I add postgresql table design to Claude?
For Postgres, copy the postgresql-table-design folder from wshobson/agents (the folder that holds SKILL.md) into ~/.claude/skills/ to use it in every Claude Code project, or into .claude/skills/ for one project. For the Claude apps, upload the zipped folder as a custom skill instead.
How recently were Postgres skills updated?
118 of the 158 Postgres skills sit in repositories that changed in the 30 days before 31 Oct 2026.
Are Postgres skills safe to install?
Installing a Postgres skill means Claude will follow its instructions and may run its scripts, so read SKILL.md and every script first: for postgresql table design, that is everything in the postgresql-table-design folder. Watch for downloads, commands that send data out, invisible characters, and text telling Claude to keep something from you.
What licences do these Postgres skills use?
Of the 50 Postgres skills listed here, 41 sit in repositories under an open licence such as MIT or Apache 2.0, and 5, such as postgresql code review and postgresql optimization, state no licence at all, which legally means you may not reuse them. The licence badge on each card tells you which is which.
More topics: every “Claude skills for…” page.