Database
PostgreSQL agent skills, page 13
PostgreSQL skills, ranked
Ranked by score. Sort bymost stars,trending,newest,recently updated
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 577 | 577.Azure Postgres Create new Azure Database for PostgreSQL Flexible Server instances and configure passwordless authentication with Microsoft Entra ID. | aiskillstore/ | 430 | — | ~1.5k | Automated safety check: Pass | No licence | yesterday |
| 578 | Turn JSON or PostgreSQL jsonb payloads into compact readable context for LLMs. | aiskillstore/ | 430 | — | ~1k | Automated safety check: Pass | No licence | yesterday |
| 579 | Build production-grade FastAPI backends with SQLModel, Dapr integration, and JWT authentication. | aiskillstore/ | 430 | — | ~2.2k | Automated safety check: Pass | No licence | yesterday |
| 580 | 580.SQL Expert Expert SQL query writing, optimization, and database schema design with support for PostgreSQL, MySQL, SQLite, and SQL Server. | aiskillstore/ | 430 | — | ~3.4k | Automated safety check: Pass | No licence | yesterday |
| 581 | A skill your agent uses when writing Go tests that need test doubles or cover multiple cases - detect the repo's mocking approach (Mockery v3, gomock, hand-written testify mocks, fakes)… | makifbaysal/ | 109 | — | ~1.6k | Automated safety check: Pass | Apache-2.0 | today |
| 582 | A skill your agent uses when changing the database schema - detect the repo's migration tool, ship a new migration in its layout, never edit an applied one, and avoid lock-unsafe DDL on a live table | makifbaysal/ | 109 | — | ~2.2k | Automated safety check: Pass | Apache-2.0 | today |
| 583 | A skill your agent uses when writing or changing a query against PostgreSQL from Go — avoiding N+1 loops, reading EXPLAIN output, indexing, and keyset pagination | makifbaysal/ | 109 | — | ~1.1k | Automated safety check: Pass | Apache-2.0 | today |
| 584 | A skill your agent uses when a test needs a database - spin up a dedicated, disposable test database (Testcontainers) seeded with known data, never a shared or production database | makifbaysal/ | 109 | — | ~908 | Automated safety check: Pass | Apache-2.0 | today |
| 585 | 585.Event Store Design and implement event stores for event-sourced systems. | LeoYeAI/ | 2.2k | — | ~3.9k | Automated safety check: Pass | MIT | 2 mo ago |
| 586 | 586.Run402 Provision Postgres databases, deploy static sites, generate images, and build full-stack webapps on Run402 using x402 micropayments. | LeoYeAI/ | 2.2k | — | ~4.8k | Automated safety check: Pass | MIT | 2 mo ago |
| 587 | 587.SQL Toolkit Query, design, migrate, and optimize SQL databases. An agent skill from LeoYeAI/openclaw-master-skills. | LeoYeAI/ | 2.2k | — | ~3k | Automated safety check: Pass | MIT | 2 mo ago |
| 588 | SQL query optimization catalog. An agent skill from revfactory/harness-100. | revfactory/ | 1.3k | — | ~1.9k | Automated safety check: Pass | Apache-2.0 | 6 mo ago |
| 589 | RDBMS-to-RDBMS data type mapping tables, RDBMS-to-NoSQL conversion patterns, character set/collation conversion, and special type handling guide. | revfactory/ | 1.3k | — | ~1.7k | Automated safety check: Pass | Apache-2.0 | 6 mo ago |
| 590 | 590.Stack Run and inspect the local pieces of Guardana — the throwaway PostgreSQL for the collector, the collector itself, a fake OpenAI-compatible endpoint to probe, the documentation site served locally… | guardana/ | 129 | — | ~568 | Automated safety check: Pass | Apache-2.0 | yesterday |
| 591 | Sync HubSpot CRM data to a data warehouse (BigQuery, Snowflake, or Postgres) for analytics and reporting. | jeremylongshore/ | 2.8k | — | ~5.7k | Automated safety check: Pass | MIT | today |
| 592 | Designs relational and document database schemas from requirements or an existing app - tables and collections, keys, relationships, constraints, indexes driven by real query patterns, ERDs, and… | OneWave-AI/ | 323 | — | ~1.6k | Automated safety check: Pass | MIT | 6 days ago |
| 593 | Guide to Metabase for open-source research data analytics and dashboards | wentorai/ | 298 | 1 repo | ~2.1k | Automated safety check: Pass | MIT | 3 mo ago |
| 594 | Database design with schema analysis, index optimization, and migration generation for PostgreSQL, MySQL, MongoDB, and DynamoDB. | borghei/ | 881 | — | ~1.6k | Automated safety check: Pass | MIT | yesterday |
| 595 | Scaffolds an xUnit integration test project for validating Oracle-to-PostgreSQL database migration behavior in .NET solutions. | boshi-xixixi/ | 275 | — | ~632 | Automated safety check: Pass | MIT | 4 mo ago |
| 596 | Using golem:rdbms/postgres from a MoonBit Golem agent. An agent skill from golemcloud/golem. | golemcloud/ | 1.5k | — | ~396 | Automated safety check: Pass | Unknown | today |
| 597 | 597.Research Use when the user prompts "research". | romeerez/ | 543 | — | ~2.3k | Automated safety check: Pass | MIT | yesterday |
| 598 | Schema design, normalization decisions, indexing strategies, and migration safety for relational databases. | curiositech/ | 243 | — | ~3.1k | Automated safety check: Pass | MIT | 1 mo ago |
| 599 | 599.Nuxt Server | Nuxt 4 server-side development with Nitro: API routes, server middleware, database integration, and backend patterns. | secondsky/ | 227 | — | ~3.2k | Automated safety check: Pass | MIT | 10 days ago |
| 600 | Explains, optimises, writes, and documents SQL queries. An agent skill from mohitagw15856/pm-claude-skills. | mohitagw15856/ | 1.4k | — | ~1.6k | Automated safety check: Pass | MIT | yesterday |
| 601 | MindsDB MCP服务器交互技能,用于通过自然语言查询和操作200+企业级数据源。当用户需要查询数据库、分析数据、创建AI模型、连接数据源(MySQL、PostgreSQL、MongoDB、Excel、CSV、Gmail、Slack等)、执行SQL查询、进行数据预测、构建知识库(RAG)、智能问答、文档检索或任何与数据库交互的任务时使用此技能。即使没有明确提到MindsDB,只要涉及数据库操… | LeoYeAI/ | 2.2k | — | ~2.5k | Automated safety check: Pass | MIT | 2 mo ago |
| 602 | 602.Zombie Brute 使用 zombie 进行多协议暴力破解。zombie 是 chainreactors 出品的高性能暴力破解工具,支持 SSH/FTP/MySQL/MSSQL/PostgreSQL/Redis/SMB/RDP/SNMP/LDAP/VNC 等 20+ 协议,内置智能字典生成和分布式模式。与 hydra 的区别:zombie… | wgpsec/ | 1.8k | — | ~489 | Automated safety check: Pass | No licence | 5 days ago |
| 603 | Creates and scaffolds a new Spring Boot project (3.x or 4.x) by downloading from Spring Initializr, generating package structure (DDD or Layered architecture), configuring JPA, SpringDoc OpenAPI… | giuseppe-trisciuoglio/ | 355 | — | ~3.4k | Automated safety check: Notes | MIT | 28 days ago |
| 604 | 604.Databases Work with MongoDB (document database, BSON documents, aggregation pipelines, Atlas cloud) and PostgreSQL (relational database, SQL queries, psql CLI, pgAdmin). | Microck/ | 403 | — | ~1.9k | Automated safety check: Notes | MIT | 1 mo ago |
| 605 | 605.SQL Translation Guide for adding SQL function translations to dbplyr backends. | Microck/ | 403 | — | ~1.3k | Automated safety check: Pass | Unknown | 1 mo ago |
| 606 | 606.Headscale Backup Manage Headscale backups, restores, or migrations with a verified SQLite snapshot and explicit recovery paths before upgrades, host moves, or disaster recovery; do not use for server deployment… | magnus919/ | 113 | — | ~1.4k | Automated safety check: Pass | MIT | 2 days ago |
| 607 | 607.Frontend Builder Builds the project's frontend under front/ end to end, unsupervised. | WeaveMindAI/ | 2k | — | ~2.6k | Automated safety check: Pass | Unknown | 2 days ago |
| 608 | PostgreSQL backup & restore playbook for the docker instance: pgdump/pgdumpall recipes, WAL archiving + PITR setup (archivemode, archivecommand, recovery.signal, recoverytargettime, timelines)… | fmflurry/ | 171 | — | ~2.3k | Automated safety check: Pass | MIT | yesterday |
| 609 | PostgreSQL container operations for the docker instance: volume persistence audit (PGDATA layout and the PG18 version-specific data-directory change), /dev/shm sizing (shmsize), pgisready… | fmflurry/ | 171 | — | ~4.4k | Automated safety check: Pass | MIT | yesterday |
| 610 | 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 | yesterday |
| 611 | PostgreSQL performance tuning for the docker instance: memory sizing vs the 1g memlimit (sharedbuffers, effectivecachesize, workmem math), checkpoint tuning (maxwalsize, checkpointcompletiontarget… | fmflurry/ | 171 | — | ~2.6k | Automated safety check: Pass | MIT | yesterday |
| 612 | 612.DB Connection A skill your agent uses when setting up database connections, especially for Neon PostgreSQL. | aiskillstore/ | 430 | — | ~3.5k | Automated safety check: Notes | No licence | yesterday |
| 613 | Deploys PostgreSQL on Kubernetes using the CloudNativePG operator with automated failover. | aiskillstore/ | 430 | — | ~2k | Automated safety check: Pass | No licence | yesterday |
| 614 | 614.Psql Run PostgreSQL queries and meta-commands via CLI. An agent skill from aiskillstore/marketplace. | aiskillstore/ | 430 | 1 repo | ~1.1k | Automated safety check: Notes | MIT | yesterday |
| 615 | 615.Tmux Manage tmux sessions for interactive background processes. An agent skill from aiskillstore/marketplace. | aiskillstore/ | 430 | 1 repo | ~1.4k | Automated safety check: Pass | MIT | yesterday |
| 616 | Set up Cloud Run Jobs with CloudSQL connection. An agent skill from divinevideo/divine-mobile. | divinevideo/ | 266 | — | ~1.4k | Automated safety check: Pass | MPL-2.0 | today |
| 617 | Fix psycopg2 "could not receive data from server: Operation timed out" or "connection already closed" errors when using Cloud SQL with long-running Python scripts. | divinevideo/ | 266 | — | ~1.1k | Automated safety check: Pass | MPL-2.0 | today |
| 618 | Debug "API returns data that doesn't exist in database" when multiple Kubernetes clusters exist (production, staging, POC). | divinevideo/ | 266 | — | ~1.3k | Automated safety check: Pass | MPL-2.0 | today |
| 619 | Fix Node.js pg-pool not reconnecting after CloudSQL connection reset (ECONNRESET). | divinevideo/ | 266 | — | ~1.2k | Automated safety check: Pass | MPL-2.0 | today |
| 620 | Fix PostgreSQL deadlock errors caused by concurrent schema initialization in worker processes. | divinevideo/ | 266 | — | ~1.1k | Automated safety check: Pass | MPL-2.0 | today |
| 621 | Optimize slow PostgreSQL inserts in Python using psycopg2. An agent skill from divinevideo/divine-mobile. | divinevideo/ | 266 | — | ~1.2k | Automated safety check: Pass | MPL-2.0 | today |
| 622 | Fix psycopg2 "IndexError: tuple index out of range" when using LIKE with parameterized queries. | divinevideo/ | 266 | — | ~1.1k | Automated safety check: Pass | MPL-2.0 | today |
| 623 | 623.Performance A skill your agent uses when diagnosing a slow HTTP endpoint or high-latency service — profiling, adding an application-level cache, offloading CPU-bound work to threads or workers, or defining a… | kid-sid/ | 189 | — | ~3.8k | Automated safety check: Pass | MIT | 2 mo ago |
| 624 | 624.Postgresql A skill your agent uses when writing complex PostgreSQL queries, diagnosing slow queries with EXPLAIN ANALYZE, designing indexes (B-tree, GIN, partial, composite), handling concurrent writes and… | kid-sid/ | 189 | — | ~3.7k | Automated safety check: Pass | MIT | 2 mo ago |