Search
PostgreSQL · Database administration
Skills
Sort:BestMost starsTrending todayTrending this weekTrending this monthNewestRecently updatedName
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 1 | Indexes reference files on Postgres schema design, indexing, partitioning, query patterns, MVCC and VACUUM, and PlanetScale-specific operations. | planetscale/ | 706 | 3 repos | ~1.8k | Automated safety check: Pass | MIT | 2 days ago |
| 2 | 2.Digoal Portable digital employee distilled from digoal's personal blog for PostgreSQL, PolarDB, DuckDB, AI+database, vector/RAG, database operations, source-code reading, technical content creation… | digoal/ | 8.6k | — | ~2.2k | Automated safety check: Pass | GPL-2.0 | today |
| 3 | PostgreSQL database documentation - SQL queries, database design, administration, performance tuning, and advanced features. Use when working with… | 2025Emma/ | 23k | 1 repo | ~19k | Automated safety check: Pass | MIT | 9 mo ago |
| 4 | Inspects, queries and carefully modifies the MoviePilot SQLite or PostgreSQL database through a bundled script that reads connection settings itself, without needing the password in the prompt. | jxxghp/ | 12k | — | ~7.3k | Automated safety check: Pass | GPL-3.0 | today |
| 5 | Guides and best practices for working with Lakebase Postgres, the database behind Neon. | smontlouis/ | 171 | 1 repo | ~2.3k | Automated safety check: Notes | GPL-3.0 | today |
| 6 | Read live production data from Bike Index through the admin OAuth token — Sidekiq and PgHero status, and the user-submitted bug reports — the same data as the cookie-gated dashboards, but… | bikeindex/ | 308 | — | ~1.9k | Automated safety check: Notes | AGPL-3.0 | today |
| 7 | Database operations runbook — backup, recovery, performance tuning, troubleshooting. | OpenDCAI/ | 449 | — | ~388 | Automated safety check: Pass | Apache-2.0 | 19 days ago |
| 8 | Guides and best practices for working with Lakebase Postgres, the database behind Neon. | usenotra/ | 256 | — | ~4.1k | Automated safety check: Notes | AGPL-3.0 | today |
| 9 | Guides scalability and performance work for VeloxDB's Tauri + Rust PostgreSQL backend and React + TanStack frontend. | veloxbase/ | 646 | — | ~1.7k | Automated safety check: Pass | MIT | 9 days ago |
| 10 | Database performance optimization, schema design, query analysis, and connection management across PostgreSQL, MySQL, MongoDB, and SQLite with ORM integration. | cin12211/ | 224 | — | ~2.8k | Automated safety check: Pass | MIT | 18 days ago |
| 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 | today |
| 12 | Guidance for Neki, PlanetScale's distributed (sharded) Postgres. Load when working with a Neki database — connecting, data topology and shard keys… | planetscale/ | 706 | — | ~2.1k | Automated safety check: Pass | MIT | 2 days ago |
| 13 | 13.DB Admin PostgreSQL database administration — backup/restore (pgdump, PITR, WAL archiving), health monitoring (connections, bloat, cache hit ratio, dead tuples), connection pooling (PgBouncer), replication… | EliasOulkadi/ | 114 | — | ~2k | Automated safety check: Notes | MIT | 4 days ago |
| 14 | 14.DB Sculptor Design database schemas with Prisma/Drizzle, PostgreSQL index strategy (B-tree, GIN, GiST, BRIN, Hash), query optimization (EXPLAIN ANALYZE), migration safety (expand/contract, zero-downtime), and… | EliasOulkadi/ | 114 | — | ~3.1k | Automated safety check: Notes | MIT | 4 days ago |
| 15 | PostgreSQL query optimization, JSONB operations, advanced indexing strategies, partitioning, connection management, and database administration. | cin12211/ | 224 | — | ~5.5k | Automated safety check: Pass | MIT | 18 days ago |
| 16 | Tunes PostgreSQL and MySQL performance by analyzing slow queries and execution plans, designing indexes, rewriting queries and adjusting configuration, one validated change at a time. | Jeffallan/ | 12k | — | ~1.6k | Automated safety check: Pass | MIT | 6 days ago |
| 17 | Tunes and administers PostgreSQL: EXPLAIN-driven query tuning, index choice, JSONB, extensions, streaming or logical replication, VACUUM and pg_stat monitoring. | Jeffallan/ | 12k | — | ~1.5k | Automated safety check: Pass | MIT | 6 days ago |
| 18 | Restore a PostgreSQL database backup to a Railway environment. | modelguide/ | 108 | — | ~562 | Automated safety check: Pass | MIT | 3 mo ago |
| 19 | Automatically discover database skills when working with SQL, PostgreSQL, MongoDB, Redis, database schema design, query optimization, migrations, connection pooling, ORMs, or database selection. | rand/ | 181 | — | ~2k | Automated safety check: Pass | MIT | 7 mo ago |
| 20 | 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 | today |
| 21 | 21.Whodb Database operations including querying, schema exploration, and data analysis. | xiaoyuge886/ | 198 | — | ~894 | Automated safety check: Pass | MIT | 2 mo ago |
| 22 | Implement database backup strategies. An agent skill from sickn33/agentic-awesome-skills. | sickn33/ | 47k | 2 repos | ~3.1k | Automated safety check: Notes | MIT | today |
| 23 | Administer PostgreSQL databases. An agent skill from sickn33/agentic-awesome-skills. | sickn33/ | 47k | 2 repos | ~2.5k | Automated safety check: Notes | MIT | today |
| 24 | Expert patterns for Neon serverless Postgres, branching, connection pooling, and Prisma/Drizzle integration Use when: neon database, serverless postgres, database branching, neon postgres, postgres… | davila7/ | 32k | 4 repos | ~396 | Automated safety check: Pass | MIT | today |
| 25 | PostgreSQL expert for query optimization, indexing, extensions, and database administration | RightNow-AI/ | 18k | — | ~830 | Automated safety check: Pass | Apache-2.0 | 3 mo ago |
| 26 | 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 |
| 27 | Guides and best practices for working with Neon Serverless Postgres. | aiskillstore/ | 430 | 4 repos | ~4.2k | Automated safety check: Notes | Apache-2.0 | today |
| 28 | Manages clusters, instances, and backups for AlloyDB for PostgreSQL, and integrates with AlloyDB MCP tools for automated database operations including AI-powered search and vector capabilities. | davila7/ | 32k | — | ~611 | Automated safety check: Pass | MIT | today |
| 29 | Automate database backup processes with scheduling, compression, and encryption. | jeremylongshore/ | 2.8k | — | ~1.5k | Automated safety check: Pass | MIT | today |
| 30 | Process use when you need to work with database operations. An agent skill from jeremylongshore/tons-of-skills-marketplace. | jeremylongshore/ | 2.8k | — | ~1.8k | Automated safety check: Pass | MIT | today |
| 31 | Process use when you need to work with database scalability. | jeremylongshore/ | 2.8k | — | ~1.9k | Automated safety check: Pass | MIT | today |
| 32 | Process use when you need to work with database sharding. An agent skill from jeremylongshore/tons-of-skills-marketplace. | jeremylongshore/ | 2.8k | — | ~1.7k | Automated safety check: Pass | MIT | today |
| 33 | Process use when you need to work with connection management. | jeremylongshore/ | 2.8k | — | ~1.9k | Automated safety check: Pass | MIT | today |
| 34 | Reads from, writes to, and manages relational databases using MATLAB Database Toolbox. | matlab/ | 1.1k | — | ~3.1k | Automated safety check: Pass | Unknown | yesterday |
| 35 | PostgreSQL optimization including indexes, query plans, partitioning, JSONB operations, and connection pooling | rohitg00/ | 2.7k | — | ~1.1k | Automated safety check: Pass | Apache-2.0 | 5 mo ago |
| 36 | 36.Mysql A skill your agent uses when designing, querying, indexing or operating a MySQL or MariaDB database and engine-specific behaviour matters — schema and type choices, index design, reading EXPLAIN… | ericrisco/ | 174 | — | ~3.7k | Automated safety check: Pass | MIT | yesterday |
| 37 | 37.Postgresdb A skill your agent uses when PostgreSQL engine behaviour decides the answer — schema and type design, index choice, reading EXPLAIN on a slow query, zero-downtime DDL and backfills, or ops (roles… | ericrisco/ | 174 | — | ~4.4k | Automated safety check: Pass | MIT | yesterday |
| 38 | Provides patterns to configure AWS RDS (Aurora, MySQL, PostgreSQL) with Spring Boot applications. | giuseppe-trisciuoglio/ | 356 | — | ~2.1k | Automated safety check: Notes | MIT | 29 days ago |
| 39 | 39.Postgres Operate PostgreSQL instances safely: configuration review, index and query-plan analysis, vacuum and bloat management, WAL archiving and point-in-time recovery, replication and failover, extensions… | magnus919/ | 116 | — | ~4k | Automated safety check: Pass | MIT | yesterday |
| 40 | Comprehensive guide for PostgreSQL psql - the interactive terminal client for PostgreSQL. | einverne/ | 121 | — | ~8.9k | Automated safety check: Pass | GPL-3.0 | 1 mo ago |
| 41 | 41.Databases Work with MongoDB (document database, BSON documents, aggregation pipelines, Atlas cloud) and PostgreSQL (relational database, SQL queries, psql CLI, pgAdmin). | Microck/ | 404 | — | ~1.9k | Automated safety check: Notes | MIT | 1 mo ago |
| 42 | Read-only PostgreSQL instance health battery: connectivity/uptime, cache hit ratio, dead tuples & autovacuum hotspots, XID wraparound distance, long-running & idle-in-transaction sessions, unused… | fmflurry/ | 171 | — | ~3.3k | Automated safety check: Pass | MIT | 2 days ago |
| 43 | A skill your agent uses when setting up database connections, especially for Neon PostgreSQL. | aiskillstore/ | 430 | — | ~3.5k | Automated safety check: Notes | No licence | today |