timescaleSkillpostgres
timescale/pg-aiguide/skills/postgres/SKILL.md
Use this skill for any PostgreSQL database work — table design, indexing, data types, constraints, extensions (pgvector, PostGIS, TimescaleDB), search, and migrations.
Claude skills and agent skills
Skills real projects publish on GitHub, most starred first. Each one says what it will make an agent do before you copy it.
Best matchesWorked for most · soon
timescaleSkill
AWSSkilldistributed postgres
awslabs/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.
timescaleSkilldesign-postgres-tables
timescale/pg-aiguide/skills/design-postgres-tables/SKILL.md
Use this skill for general PostgreSQL table design.
OpenAISkillsupabase-postgres-best-practices
openai/plugins/plugins/build-web-apps/skills/supabase-best-practices/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.
OpenAISkillsupabase-postgres-best-practices
openai/plugins/plugins/supabase/skills/supabase-postgres-best-practices/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.
GitHubSkillpostgresql-code-review
github/awesome-copilot/skills/postgresql-code-review/SKILL.md
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 features like Row Level Security (RLS).
GitHubSkillpostgresql-optimization
github/awesome-copilot/skills/postgresql-optimization/SKILL.md
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 PostgreSQL extensions ecosystem.
skyllwtSkillposter
skyllwt/AutoSci/.claude/skills/poster/SKILL.md
Generate an academic poster from a drafted paper — distill sections into a single-page HTML poster with figures and inter-section transitions
SupabaseSkillsupabase-postgres-best-practices
supabase/agent-skills/skills/supabase-postgres-best-practices/SKILL.md
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, migrations and declarative schema files, RLS policies and the tests that verify them, indexes, triggers, database functions, queues and scheduled jobs (pg_cron, pgmq), vector/semantic search (pgvector), and restoring dumps (pg_restore) or importing data. Also load it when diagnosing slow queries, high CPU, timeouts, EXPLAIN plans, connection exhaustion, locking, bloat, or rows visible to the wrong user or tenant. This is not just a performance guide — schema, migration, security, and SQL authoring tasks need these rules too, even for a one-column change or a single query.
AWSSkillamazon-aurora-postgresql
aws/agent-toolkit-for-aws/skills/specialized-skills/database-skills/amazon-aurora-postgresql/SKILL.md
Amazon Aurora PostgreSQL — creates, modifies, and advises on Aurora PostgreSQL clusters specifically (PostgreSQL-compatible engine, Aurora serverless, express configuration, pgvector, Babelfish). Trigger for Aurora PostgreSQL cluster operations, express-configuration quick-start, ACU sizing, I/O-Optimized storage, commitment pricing, or PostgreSQL upgrade planning. For Aurora MySQL, use amazon-aurora-mysql instead. Contains safety guardrails, express-first routing, and response templates that override defaults.
OpenAISkillposthog
openai/plugins/plugins/posthog/skills/posthog/SKILL.md
Analyze product data and manage product tooling in PostHog. Use when the user wants product analytics or insights, HogQL/SQL queries, feature flags, experiments and A/B tests, error tracking, session replay, surveys, LLM analytics, dashboards, data warehouse, or PostHog documentation.
GitHubSkillcreating-oracle-to-postgres-migration-bug-report
github/awesome-copilot/skills/creating-oracle-to-postgres-migration-bug-report/SKILL.md
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.
GitHubSkillcreating-oracle-to-postgres-master-migration-plan
github/awesome-copilot/skills/creating-oracle-to-postgres-master-migration-plan/SKILL.md
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 assessing which .NET projects contain Oracle dependencies.
GitHubSkillmigrating-oracle-to-postgres-data-access-code
github/awesome-copilot/skills/migrating-oracle-to-postgres-data-access-code/SKILL.md
Migrates .NET/C# data access code from Oracle to PostgreSQL (Npgsql). Replaces Oracle NuGet packages, rewrites OracleConnection/OracleCommand/OracleDataReader usage, fixes DbType mappings, updates stored procedure invocation patterns, and adapts connection string configuration. Use when migrating the application code layer of a .NET project during an Oracle-to-PostgreSQL database migration.
GitHubSkillmigrating-oracle-to-postgres-stored-procedures
github/awesome-copilot/skills/migrating-oracle-to-postgres-stored-procedures/SKILL.md
Migrates Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL. Translates Oracle-specific syntax, preserves method signatures and type-anchored parameters, leverages orafce where appropriate, and applies explicit collation mapping (`COLLATE "C"` only when appropriate, locale collations when required). Use when converting Oracle stored procedures or functions to PostgreSQL equivalents during a database migration.
GitHubSkillreviewing-oracle-to-postgres-migration
github/awesome-copilot/skills/reviewing-oracle-to-postgres-migration/SKILL.md
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, materialized-view refresh requirements, timestamps, concurrent transactions, etc.). Use when planning a database migration, reviewing migration artifacts, or validating that integration tests cover Oracle/PostgreSQL differences.
GitHubSkillplanning-oracle-to-postgres-migration-integration-testing
github/awesome-copilot/skills/planning-oracle-to-postgres-migration-integration-testing/SKILL.md
Creates an integration testing plan for .NET data access artifacts during Oracle-to-PostgreSQL database migrations. Analyzes a single project to identify repositories, DAOs, and service layers that interact with the database, then produces a structured testing plan. Use when planning integration test coverage for a migrated project, identifying which data access methods need tests, or preparing for Oracle-to-PostgreSQL migration validation.
macro-incSkilldump-schema
macro-inc/macro/.agents/skills/dump-schema/SKILL.md
Dump clean Postgres schema to a file and copy path to clipboard.
AnthropicSkillwrite-query
anthropics/knowledge-work-plugins/data/skills/write-query/SKILL.md
Write optimized SQL for your dialect with best practices. Use when translating a natural-language data need into SQL, building a multi-CTE query with joins and aggregations, optimizing a query against a large partitioned table, or getting dialect-specific syntax for Snowflake, BigQuery, Postgres, etc.
PostHogSkillmonitoring-ingestion-pipeline
PostHog/posthog/.agents/skills/monitoring-ingestion-pipeline/SKILL.md
Guide for using the Grafana MCP to monitor and diagnose the Node.js ingestion pipeline workers in production. Use when investigating event lag, drops, pipeline errors, person/group processing, Kafka consumer health, Redis, Postgres, ClickHouse downstream health, or any ingestion worker question. Covers prod-us and prod-eu environments.
About skills
What is a Claude skill?
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.
How do I use one I find here?
Copy the folder into your project's .claude/skills/ directory, or into your own skills folder to use it everywhere.
What do the warnings mean?
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.
Which skills worked for people?
Open a skill to see its discussion. Reports from people and their agents are coming.