Topic · Databases
Best database administration skills, page 2
Database administration skills, ranked
Ranked by score. Sort bymost stars,trending,newest,recently updated
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 49 | PostgreSQL query optimization, JSONB operations, advanced indexing strategies, partitioning, connection management, and database administration. | cin12211/ | 223 | — | ~5.5k | Automated safety check: Pass | MIT | 16 days ago |
| 50 | 50.Prisma Prisma ORM patterns including Prisma Client usage, queries, mutations, relations, transactions, and schema management. | blencorp/ | 106 | — | ~2.7k | Automated safety check: Pass | MIT | 10 mo ago |
| 51 | Replication lag root cause analysis with automated resolution workflow. | openocta/ | 166 | — | ~2.6k | Automated safety check: Pass | MIT | 3 mo ago |
| 52 | 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 | 4 days ago |
| 53 | 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 | 4 days ago |
| 54 | Oracle Database guidance for SQL, PL/SQL, SQLcl, ORDS, Oracle Vector SDK, administration, app development, performance, security, migrations, and agent-safe database workflows. | oracle/ | 872 | — | ~1.4k | Automated safety check: Pass | UPL-1.0 | yesterday |
| 55 | Diagnoses and fixes Lunora performance problems — full-table scans, missing indexes, OCC write conflicts, oversized subscriptions, and sharding/.global() scaling. | anolilab/ | 283 | — | ~2.4k | Automated safety check: Pass | Unknown | today |
| 56 | LiteLLM-RS provider system in two tiers - data-driven OpenAI-compatible catalog entries auto-routed through OpenAILikeProvider, plus code-based provider modules implementing the LLMProvider trait… | majiayu000/ | 116 | — | ~4.9k | Automated safety check: Pass | MIT | yesterday |
| 57 | Restore a PostgreSQL database backup to a Railway environment. | modelguide/ | 108 | — | ~562 | Automated safety check: Pass | MIT | 3 mo ago |
| 58 | Triage a tt-metal uplift diff or digest of TTFATAL validation changes against what tt-mlir guarantees at each optimization level (0: workarounds only, 1: optimizer with DRAM-only fallback, 2: L1… | tenstorrent/ | 311 | — | ~7.8k | Automated safety check: Pass | Apache-2.0 | today |
| 59 | Expand a hard-to-build niche list from ~10 known-good seed companies into a full qualified TAM. | growthenginenowoslawski/ | 740 | — | ~2.7k | Automated safety check: Notes | MIT | 2 days ago |
| 60 | Creates AsyncRedux (Flutter) asynchronous actions for API calls, database operations, and other async work. | marcglasberg/ | 238 | — | ~1.8k | Automated safety check: Pass | Unknown | yesterday |
| 61 | Specialized skill for building production-ready Discord bots. | davila7/ | 32k | 6 repos | ~2k | Automated safety check: Pass | MIT | yesterday |
| 62 | Prisma ORM expert for schema design, migrations, query optimization, relations modeling, and database operations. | davila7/ | 32k | 6 repos | ~2.6k | Automated safety check: Pass | MIT | yesterday |
| 63 | Reads keys and server state from Redis instances configured in .env through a read-only Python client, choosing connections by label or index. | evolution-foundation/ | 544 | — | ~1.3k | Automated safety check: Notes | Unknown | 4 mo ago |
| 64 | 64.Simpy Builds, inspects, tests, and analyzes bounded process-based discrete-event simulations with SimPy. | K-Dense-AI/ | 48k | 1 repo | ~3.6k | Automated safety check: Notes | MIT | 2 days ago |
| 65 | A concise feature matrix for deciding which PlanetScale safety, observability, and automation recommendations apply by engine. | planetscale/ | 132 | — | ~1.4k | Automated safety check: Pass | MIT | 4 days ago |
| 66 | 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 |
| 67 | 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 | yesterday |
| 68 | Azure Resource Manager SDK for Redis in .NET. An agent skill from microsoft/skills. | microsoft/ | 3.1k | 5 repos | ~3k | Automated safety check: Pass | MIT | yesterday |
| 69 | 69.Zarr Python Stores and queries chunked N-D scientific arrays with Zarr-Python 3, including codecs, sharding, S3/GCS storage, and NumPy/Dask/Xarray integration. | K-Dense-AI/ | 48k | 1 repo | ~2.2k | Automated safety check: Notes | MIT | 2 days ago |
| 70 | 70.Whodb Database operations including querying, schema exploration, and data analysis. | xiaoyuge886/ | 198 | — | ~894 | Automated safety check: Pass | MIT | 2 mo ago |
| 71 | Compare GWAS studies, perform meta-analyses, and assess replication across cohorts. | wu-yc/ | 1.1k | 2 repos | ~2.9k | Automated safety check: Pass | No licence | 6 mo ago |
| 72 | 72.Rls Patterns Row Level Security patterns for database operations. An agent skill from bybren-llc/safe-agentic-workflow. | bybren-llc/ | 421 | — | ~1.5k | Automated safety check: Pass | MIT | 2 mo ago |
| 73 | 73.AWS Rds Provision and manage RDS databases. An agent skill from sickn33/agentic-awesome-skills. | sickn33/ | 47k | 2 repos | ~3.3k | Automated safety check: Pass | MIT | yesterday |
| 74 | 74.AWS S3 Configure S3 buckets, policies, and lifecycle rules. An agent skill from sickn33/agentic-awesome-skills. | sickn33/ | 47k | 2 repos | ~3.1k | Automated safety check: Pass | MIT | yesterday |
| 75 | Implement database backup strategies. An agent skill from sickn33/agentic-awesome-skills. | sickn33/ | 47k | 2 repos | ~3.1k | Automated safety check: Notes | MIT | yesterday |
| 76 | 76.Mongodb Administer MongoDB databases. An agent skill from sickn33/agentic-awesome-skills. | sickn33/ | 47k | 2 repos | ~2.7k | Automated safety check: Notes | MIT | yesterday |
| 77 | 77.Mysql Administer MySQL/MariaDB databases. An agent skill from sickn33/agentic-awesome-skills. | sickn33/ | 47k | 2 repos | ~2.7k | Automated safety check: Notes | MIT | yesterday |
| 78 | Administer PostgreSQL databases. An agent skill from sickn33/agentic-awesome-skills. | sickn33/ | 47k | 2 repos | ~2.5k | Automated safety check: Notes | MIT | yesterday |
| 79 | Run large-scale batch NER, PII extraction, or de-identification over many clinical notes on-device with OpenMed, with sharding, checkpointing, resumability, and append-only JSONL output. | maziyarpanahi/ | 5.5k | — | ~2.2k | Automated safety check: Pass | Apache-2.0 | 2 days ago |
| 80 | Govern Playwright TypeScript regression suites across many tests. | fugazi/ | 247 | — | ~1.4k | Automated safety check: Pass | MIT | 4 days ago |
| 81 | PostgreSQL expert for query optimization, indexing, extensions, and database administration | RightNow-AI/ | 18k | — | ~830 | Automated safety check: Pass | Apache-2.0 | 3 mo ago |
| 82 | 82.AWS Aurora AWS Aurora Serverless v2, RDS Proxy, Data API, connection pooling | alinaqi/ | 707 | — | ~3.9k | Automated safety check: Pass | MIT | 13 days ago |
| 83 | 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 | 3 repos | ~396 | Automated safety check: Pass | MIT | yesterday |
| 84 | Proven workflow architectural patterns from real n8n workflows. | davila7/ | 32k | 1 repo | ~2.8k | Automated safety check: Pass | MIT | yesterday |
| 85 | Configures the security features of the Harbor open-source container registry - integrated Trivy scanning, Cosign and Notary content trust policies, project-level RBAC, immutable tag and retention… | mukul975/ | 34k | — | ~1.9k | Automated safety check: Pass | Apache-2.0 | 1 mo ago |
| 86 | Detect DCSync attacks (MITRE ATT&CK T1003.006) by analyzing Windows Event ID 4662 (AccessMask 0x100) for DS-Replication-Get-Changes and DS-Replication-Get-Changes-All requests issued by… | mukul975/ | 34k | — | ~897 | Automated safety check: Pass | Apache-2.0 | 1 mo ago |
| 87 | Audits and hardens process historian servers (OSIsoft PI, Honeywell PHD, GE Proficy, AVEVA Historian) in OT environments: Purdue-level network placement, interface access control, secure DMZ… | mukul975/ | 34k | — | ~3.8k | Automated safety check: Pass | Apache-2.0 | 1 mo ago |
| 88 | Scaffold and run a reproducible Monte Carlo simulation study in R — a declared assumption regime, a parameterized DGP, an estimator grid, a seeded replication loop, and a summary of bias, RMSE… | pedrohcgs/ | 1.6k | — | ~2.9k | Automated safety check: Notes | MIT | 10 days ago |
| 89 | End-to-end Stata replication pipeline — scaffolds numbered .do files in scripts/stata/, executes them via the stata-mcp MCP server, captures logs and outputs to output/, and produces… | pedrohcgs/ | 1.6k | — | ~2.1k | Automated safety check: Notes | MIT | 10 days ago |
| 90 | Design and implement disaster recovery strategies with RTO/RPO planning, database backups, Kubernetes DR, cross-region replication, and chaos engineering testing. | ancoleman/ | 526 | — | ~3.1k | Automated safety check: Pass | MIT | 10 mo ago |
| 91 | A skill your agent uses when assembling the AEA Data and Code Availability deposit for an AER, AER:Insights, or AEJ acceptance, writing the README, or auditing a replication package before the AEA… | brycewang-stanford/ | 4.5k | 1 repo | ~2.8k | Automated safety check: Pass | Unknown | 2 days ago |
| 92 | Use the @upstash/redis HTTP client for caching, sessions, counters, and Redis data structures from serverless and edge runtimes without connection pooling. | sickn33/ | 47k | 1 repo | ~1.5k | Automated safety check: Pass | MIT | yesterday |
| 93 | 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 | yesterday |
| 94 | In-memory caching in Go using samber/hot — eviction (LRU, LFU, TinyLFU, S3FIFO, ARC, SIEVE), TTL, loaders, sharding, stale-while-revalidate, missing-key caching, metrics. | context-labs/ | 1.1k | — | ~1.9k | Automated safety check: Pass | MIT | 2 days ago |
| 95 | Pattern library discovery for pattern-first development. An agent skill from bybren-llc/safe-agentic-workflow. | bybren-llc/ | 421 | — | ~533 | Automated safety check: Pass | MIT | 2 mo ago |
| 96 | A skill your agent uses when implementing or debugging the Gameplay Ability System in C++ — abilities, effects, attributes, cues and the AbilitySystemComponent. | quodsoler/ | 359 | — | ~6.6k | Automated safety check: Pass | MIT | 9 days ago |