Data & backend
10,137 rows, by stacks then stars
233 of these skill files have been read, by 258 distinct authors, and what they tell an agent counted. What Data & backend authors agree on, and what they forbid
sairam0424/MindForge/.mindforge/skills/rate-limiting-design Skill
0★ repoMindForge: The Enterprise Agentic Framework for Claude Code & Antigravity. High-performance autonomous execution, wave-parallelism, and multi-tier governance for production-grade AI engineering.
sairam0424/MindForge/.mindforge/skills/stream-processing Skill
0★ repoMindForge: The Enterprise Agentic Framework for Claude Code & Antigravity. High-performance autonomous execution, wave-parallelism, and multi-tier governance for production-grade AI engineering.
Marchelleintrinsical938/skills/skills/pubmed-database Skill
0★ repoMake sure to use this skill whenever the user asks about biomedical or life sciences literature, medical research, clinical trials, systematic reviews, meta-analyses, drug studies, or any topic that might be in PubMed or MEDLINE — even if they don't mention PubMed explicitly. Also invoke for questions about specific PMIDs, DOIs, journal articles, abstracts, or citation lookups. Trigger phrases include: pubmed, medline, ncbi, biomedical research, medical literature, clinical trial, systematic review, meta-analysis, randomized controlled trial, RCT, MeSH terms, PMID, biomedical journal, life sciences paper, find article by author, find study on, search medical literature, evidence-based medicine, drug efficacy study, cancer research papers, diabetes research, cardiovascular study, neurology research, infectious disease literature, genomics paper, CRISPR study, COVID-19 research, vaccine efficacy study, find papers on, what does the literature say about, research on treatment of, studies on, cite this paper, look up this PMID, what papers exist on, what is the evidence for, find me studies about, medical journal search, biomedical database, abstract for paper, find citation, citation lookup, journal article search.
asong56/skills/02-define/api-design Skill
0★ repoREST API design patterns including resource naming, status codes, pagination, filtering, error responses, versioning, and rate limiting for production APIs.
asong56/skills/03-build/data-infra/clickhouse-io Skill
0★ repoClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
asong56/skills/03-build/data-infra/database-migrations Skill
0★ repoDatabase migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL, and common ORMs (Prisma, Drizzle, Kysely, Django, TypeORM, golang-migrate).
asong56/skills/03-build/data-infra/mysql-patterns Skill
0★ repoMySQL and MariaDB schema, query, indexing, transaction, replication, and connection-pool patterns for production backends.
asong56/skills/03-build/data-infra/postgres-patterns Skill
0★ repoPostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.
asong56/skills/03-build/data-infra/prisma-patterns Skill
0★ repoPrisma ORM patterns for TypeScript backends — schema design, query optimization, transactions, pagination, and critical traps like updateMany returning count not records, $transaction timeouts, migrate dev resetting the DB, @updatedAt skipped on b...
asong56/skills/03-build/data-infra/redis-patterns Skill
0★ repoRedis data structure patterns, caching strategies, distributed locks, rate limiting, pub/sub, and connection management for production applications.
asong56/skills/03-build/js-ts/backend-patterns Skill
0★ repoBackend architecture patterns, API design, database optimization, and server-side best practices for Node.js, Express, and Next.js API routes.
asong56/skills/03-build/python/fastapi-patterns Skill
0★ repoFastAPI best practices covering project structure, Pydantic v2 schemas, dependency injection, async handlers, authentication, authorization, transactional service layers, and testing with httpx and pytest.
asong56/skills/08-extend/data-scraper-agent Skill
0★ repoBuild a fully automated AI-powered data collection agent for any public source — job boards, prices, news, GitHub, sports, anything. Scrapes on a schedule, enriches data with a free LLM (Gemini Flash), stores results in Notion/Sheets/Supabase, and...
genaptic/skillsets/dist/dev/claude/plugins/postgres-databases/skills/postgres-backup-recovery Skill
0★ repoDesign and assess PostgreSQL backup, WAL archiving, point-in-time recovery, retention, encryption, immutability, monitoring, restore runbooks, and recovery exercises against scenario-specific RPO and RTO. Use when recoverability or backup assurance is the goal. Do not use for routine high-availability tuning, query diagnosis, schema modeling, or migration sequencing.
genaptic/skillsets/dist/dev/claude/plugins/postgres-databases/skills/postgres-index-design Skill
0★ repoDesign, review, consolidate, or retire PostgreSQL indexes using proven constraints and query plans, covering access methods, key order, operator classes, INCLUDE, partial and expression predicates, uniqueness, overlap, total cost, and rollout. Use when an index is the established intervention. Do not use to diagnose an unexplained slow query or to execute a production migration.
genaptic/skillsets/dist/dev/claude/plugins/postgres-databases/skills/postgres-migration-safety Skill
0★ repoPlan and review PostgreSQL production changes for locks, scans, rewrites, compatibility, bounded backfills, constraint validation, concurrent indexes, replication, observability, failure cleanup, and rollback or roll-forward. Use when a target schema or data change is approved for rollout. Do not use to choose the domain model, diagnose a query, or design the backup program.
Postgres query performance review
genaptic/skillsets/dist/dev/claude/plugins/postgres-databases/skills/postgres-query-performance-review Skill
0★ repoDiagnose PostgreSQL statement latency using sanitized SQL, EXPLAIN evidence, cardinality, buffers, temp work, joins, statistics, waits, parameters, and representative experiments. Use when a query or workload is slow, unstable, or regressed. Do not use for greenfield schema design, broad schema audits, or choosing an index without statement-level evidence.
genaptic/skillsets/dist/dev/claude/plugins/postgres-databases/skills/postgres-schema-design Skill
0★ repoDesign a new PostgreSQL schema from domain invariants and workloads, covering keys, types, nullability, constraints, relationships, tenancy, ownership, RLS, partitioning, index intent, and evolution. Use when creating or substantially reshaping a data model. Do not use for auditing an already deployed schema, diagnosing one slow query, or executing a production migration.
genaptic/skillsets/dist/dev/claude/plugins/postgres-databases/skills/postgres-schema-review Skill
0★ repoAudit an existing PostgreSQL schema and deployed catalog state for integrity, ownership, privileges, search-path exposure, constraints, RLS, partitions, indexes, and operational drift. Use when reviewing current DDL, dumps, migrations, or catalog snapshots. Do not use for greenfield data modeling, one slow-query diagnosis, or applying remediation in production.
genaptic/skillsets/dist/dev/codex/plugins/postgres-databases/skills/postgres-backup-recovery Skill
0★ repoDesign and assess PostgreSQL backup, WAL archiving, point-in-time recovery, retention, encryption, immutability, monitoring, restore runbooks, and recovery exercises against scenario-specific RPO and RTO. Use when recoverability or backup assurance is the goal. Do not use for routine high-availability tuning, query diagnosis, schema modeling, or migration sequencing.
genaptic/skillsets/dist/dev/codex/plugins/postgres-databases/skills/postgres-index-design Skill
0★ repoDesign, review, consolidate, or retire PostgreSQL indexes using proven constraints and query plans, covering access methods, key order, operator classes, INCLUDE, partial and expression predicates, uniqueness, overlap, total cost, and rollout. Use when an index is the established intervention. Do not use to diagnose an unexplained slow query or to execute a production migration.
genaptic/skillsets/dist/dev/codex/plugins/postgres-databases/skills/postgres-migration-safety Skill
0★ repoPlan and review PostgreSQL production changes for locks, scans, rewrites, compatibility, bounded backfills, constraint validation, concurrent indexes, replication, observability, failure cleanup, and rollback or roll-forward. Use when a target schema or data change is approved for rollout. Do not use to choose the domain model, diagnose a query, or design the backup program.
Postgres query performance review
genaptic/skillsets/dist/dev/codex/plugins/postgres-databases/skills/postgres-query-performance-review Skill
0★ repoDiagnose PostgreSQL statement latency using sanitized SQL, EXPLAIN evidence, cardinality, buffers, temp work, joins, statistics, waits, parameters, and representative experiments. Use when a query or workload is slow, unstable, or regressed. Do not use for greenfield schema design, broad schema audits, or choosing an index without statement-level evidence.
genaptic/skillsets/dist/dev/codex/plugins/postgres-databases/skills/postgres-schema-design Skill
0★ repoDesign a new PostgreSQL schema from domain invariants and workloads, covering keys, types, nullability, constraints, relationships, tenancy, ownership, RLS, partitioning, index intent, and evolution. Use when creating or substantially reshaping a data model. Do not use for auditing an already deployed schema, diagnosing one slow query, or executing a production migration.
genaptic/skillsets/dist/dev/codex/plugins/postgres-databases/skills/postgres-schema-review Skill
0★ repoAudit an existing PostgreSQL schema and deployed catalog state for integrity, ownership, privileges, search-path exposure, constraints, RLS, partitions, indexes, and operational drift. Use when reviewing current DDL, dumps, migrations, or catalog snapshots. Do not use for greenfield data modeling, one slow-query diagnosis, or applying remediation in production.
genaptic/skillsets/dist/dev/opencode/shared/postgres-databases/postgres-backup-recovery Skill
0★ repoDesign and assess PostgreSQL backup, WAL archiving, point-in-time recovery, retention, encryption, immutability, monitoring, restore runbooks, and recovery exercises against scenario-specific RPO and RTO. Use when recoverability or backup assurance is the goal. Do not use for routine high-availability tuning, query diagnosis, schema modeling, or migration sequencing.
genaptic/skillsets/dist/dev/opencode/shared/postgres-databases/postgres-index-design Skill
0★ repoDesign, review, consolidate, or retire PostgreSQL indexes using proven constraints and query plans, covering access methods, key order, operator classes, INCLUDE, partial and expression predicates, uniqueness, overlap, total cost, and rollout. Use when an index is the established intervention. Do not use to diagnose an unexplained slow query or to execute a production migration.
genaptic/skillsets/dist/dev/opencode/shared/postgres-databases/postgres-migration-safety Skill
0★ repoPlan and review PostgreSQL production changes for locks, scans, rewrites, compatibility, bounded backfills, constraint validation, concurrent indexes, replication, observability, failure cleanup, and rollback or roll-forward. Use when a target schema or data change is approved for rollout. Do not use to choose the domain model, diagnose a query, or design the backup program.
Postgres query performance review
genaptic/skillsets/dist/dev/opencode/shared/postgres-databases/postgres-query-performance-review Skill
0★ repoDiagnose PostgreSQL statement latency using sanitized SQL, EXPLAIN evidence, cardinality, buffers, temp work, joins, statistics, waits, parameters, and representative experiments. Use when a query or workload is slow, unstable, or regressed. Do not use for greenfield schema design, broad schema audits, or choosing an index without statement-level evidence.
genaptic/skillsets/dist/dev/opencode/shared/postgres-databases/postgres-schema-design Skill
0★ repoDesign a new PostgreSQL schema from domain invariants and workloads, covering keys, types, nullability, constraints, relationships, tenancy, ownership, RLS, partitioning, index intent, and evolution. Use when creating or substantially reshaping a data model. Do not use for auditing an already deployed schema, diagnosing one slow query, or executing a production migration.
genaptic/skillsets/dist/dev/opencode/shared/postgres-databases/postgres-schema-review Skill
0★ repoAudit an existing PostgreSQL schema and deployed catalog state for integrity, ownership, privileges, search-path exposure, constraints, RLS, partitions, indexes, and operational drift. Use when reviewing current DDL, dumps, migrations, or catalog snapshots. Do not use for greenfield data modeling, one slow-query diagnosis, or applying remediation in production.
genaptic/skillsets/dist/preview/claude/plugins/postgres-databases/skills/postgres-backup-recovery Skill
0★ repoDesign and assess PostgreSQL backup, WAL archiving, point-in-time recovery, retention, encryption, immutability, monitoring, restore runbooks, and recovery exercises against scenario-specific RPO and RTO. Use when recoverability or backup assurance is the goal. Do not use for routine high-availability tuning, query diagnosis, schema modeling, or migration sequencing.
genaptic/skillsets/dist/preview/claude/plugins/postgres-databases/skills/postgres-index-design Skill
0★ repoDesign, review, consolidate, or retire PostgreSQL indexes using proven constraints and query plans, covering access methods, key order, operator classes, INCLUDE, partial and expression predicates, uniqueness, overlap, total cost, and rollout. Use when an index is the established intervention. Do not use to diagnose an unexplained slow query or to execute a production migration.
genaptic/skillsets/dist/preview/claude/plugins/postgres-databases/skills/postgres-migration-safety Skill
0★ repoPlan and review PostgreSQL production changes for locks, scans, rewrites, compatibility, bounded backfills, constraint validation, concurrent indexes, replication, observability, failure cleanup, and rollback or roll-forward. Use when a target schema or data change is approved for rollout. Do not use to choose the domain model, diagnose a query, or design the backup program.
Postgres query performance review
genaptic/skillsets/dist/preview/claude/plugins/postgres-databases/skills/postgres-query-performance-review Skill
0★ repoDiagnose PostgreSQL statement latency using sanitized SQL, EXPLAIN evidence, cardinality, buffers, temp work, joins, statistics, waits, parameters, and representative experiments. Use when a query or workload is slow, unstable, or regressed. Do not use for greenfield schema design, broad schema audits, or choosing an index without statement-level evidence.
genaptic/skillsets/dist/preview/claude/plugins/postgres-databases/skills/postgres-schema-design Skill
0★ repoDesign a new PostgreSQL schema from domain invariants and workloads, covering keys, types, nullability, constraints, relationships, tenancy, ownership, RLS, partitioning, index intent, and evolution. Use when creating or substantially reshaping a data model. Do not use for auditing an already deployed schema, diagnosing one slow query, or executing a production migration.
genaptic/skillsets/dist/preview/claude/plugins/postgres-databases/skills/postgres-schema-review Skill
0★ repoAudit an existing PostgreSQL schema and deployed catalog state for integrity, ownership, privileges, search-path exposure, constraints, RLS, partitions, indexes, and operational drift. Use when reviewing current DDL, dumps, migrations, or catalog snapshots. Do not use for greenfield data modeling, one slow-query diagnosis, or applying remediation in production.
genaptic/skillsets/dist/preview/codex/plugins/postgres-databases/skills/postgres-backup-recovery Skill
0★ repoDesign and assess PostgreSQL backup, WAL archiving, point-in-time recovery, retention, encryption, immutability, monitoring, restore runbooks, and recovery exercises against scenario-specific RPO and RTO. Use when recoverability or backup assurance is the goal. Do not use for routine high-availability tuning, query diagnosis, schema modeling, or migration sequencing.
genaptic/skillsets/dist/preview/codex/plugins/postgres-databases/skills/postgres-index-design Skill
0★ repoDesign, review, consolidate, or retire PostgreSQL indexes using proven constraints and query plans, covering access methods, key order, operator classes, INCLUDE, partial and expression predicates, uniqueness, overlap, total cost, and rollout. Use when an index is the established intervention. Do not use to diagnose an unexplained slow query or to execute a production migration.
genaptic/skillsets/dist/preview/codex/plugins/postgres-databases/skills/postgres-migration-safety Skill
0★ repoPlan and review PostgreSQL production changes for locks, scans, rewrites, compatibility, bounded backfills, constraint validation, concurrent indexes, replication, observability, failure cleanup, and rollback or roll-forward. Use when a target schema or data change is approved for rollout. Do not use to choose the domain model, diagnose a query, or design the backup program.
Postgres query performance review
genaptic/skillsets/dist/preview/codex/plugins/postgres-databases/skills/postgres-query-performance-review Skill
0★ repoDiagnose PostgreSQL statement latency using sanitized SQL, EXPLAIN evidence, cardinality, buffers, temp work, joins, statistics, waits, parameters, and representative experiments. Use when a query or workload is slow, unstable, or regressed. Do not use for greenfield schema design, broad schema audits, or choosing an index without statement-level evidence.
genaptic/skillsets/dist/preview/codex/plugins/postgres-databases/skills/postgres-schema-design Skill
0★ repoDesign a new PostgreSQL schema from domain invariants and workloads, covering keys, types, nullability, constraints, relationships, tenancy, ownership, RLS, partitioning, index intent, and evolution. Use when creating or substantially reshaping a data model. Do not use for auditing an already deployed schema, diagnosing one slow query, or executing a production migration.
genaptic/skillsets/dist/preview/codex/plugins/postgres-databases/skills/postgres-schema-review Skill
0★ repoAudit an existing PostgreSQL schema and deployed catalog state for integrity, ownership, privileges, search-path exposure, constraints, RLS, partitions, indexes, and operational drift. Use when reviewing current DDL, dumps, migrations, or catalog snapshots. Do not use for greenfield data modeling, one slow-query diagnosis, or applying remediation in production.
genaptic/skillsets/dist/preview/opencode/shared/postgres-databases/postgres-backup-recovery Skill
0★ repoDesign and assess PostgreSQL backup, WAL archiving, point-in-time recovery, retention, encryption, immutability, monitoring, restore runbooks, and recovery exercises against scenario-specific RPO and RTO. Use when recoverability or backup assurance is the goal. Do not use for routine high-availability tuning, query diagnosis, schema modeling, or migration sequencing.
genaptic/skillsets/dist/preview/opencode/shared/postgres-databases/postgres-index-design Skill
0★ repoDesign, review, consolidate, or retire PostgreSQL indexes using proven constraints and query plans, covering access methods, key order, operator classes, INCLUDE, partial and expression predicates, uniqueness, overlap, total cost, and rollout. Use when an index is the established intervention. Do not use to diagnose an unexplained slow query or to execute a production migration.
genaptic/skillsets/dist/preview/opencode/shared/postgres-databases/postgres-migration-safety Skill
0★ repoPlan and review PostgreSQL production changes for locks, scans, rewrites, compatibility, bounded backfills, constraint validation, concurrent indexes, replication, observability, failure cleanup, and rollback or roll-forward. Use when a target schema or data change is approved for rollout. Do not use to choose the domain model, diagnose a query, or design the backup program.
Postgres query performance review
genaptic/skillsets/dist/preview/opencode/shared/postgres-databases/postgres-query-performance-review Skill
0★ repoDiagnose PostgreSQL statement latency using sanitized SQL, EXPLAIN evidence, cardinality, buffers, temp work, joins, statistics, waits, parameters, and representative experiments. Use when a query or workload is slow, unstable, or regressed. Do not use for greenfield schema design, broad schema audits, or choosing an index without statement-level evidence.
genaptic/skillsets/dist/preview/opencode/shared/postgres-databases/postgres-schema-design Skill
0★ repoDesign a new PostgreSQL schema from domain invariants and workloads, covering keys, types, nullability, constraints, relationships, tenancy, ownership, RLS, partitioning, index intent, and evolution. Use when creating or substantially reshaping a data model. Do not use for auditing an already deployed schema, diagnosing one slow query, or executing a production migration.
genaptic/skillsets/dist/preview/opencode/shared/postgres-databases/postgres-schema-review Skill
0★ repoAudit an existing PostgreSQL schema and deployed catalog state for integrity, ownership, privileges, search-path exposure, constraints, RLS, partitions, indexes, and operational drift. Use when reviewing current DDL, dumps, migrations, or catalog snapshots. Do not use for greenfield data modeling, one slow-query diagnosis, or applying remediation in production.
genaptic/skillsets/packs/shared/postgres-databases/skills/postgres-backup-recovery Skill
0★ repoDesign and assess PostgreSQL backup, WAL archiving, point-in-time recovery, retention, encryption, immutability, monitoring, restore runbooks, and recovery exercises against scenario-specific RPO and RTO. Use when recoverability or backup assurance is the goal. Do not use for routine high-availability tuning, query diagnosis, schema modeling, or migration sequencing.
genaptic/skillsets/packs/shared/postgres-databases/skills/postgres-index-design Skill
0★ repoDesign, review, consolidate, or retire PostgreSQL indexes using proven constraints and query plans, covering access methods, key order, operator classes, INCLUDE, partial and expression predicates, uniqueness, overlap, total cost, and rollout. Use when an index is the established intervention. Do not use to diagnose an unexplained slow query or to execute a production migration.
genaptic/skillsets/packs/shared/postgres-databases/skills/postgres-migration-safety Skill
0★ repoPlan and review PostgreSQL production changes for locks, scans, rewrites, compatibility, bounded backfills, constraint validation, concurrent indexes, replication, observability, failure cleanup, and rollback or roll-forward. Use when a target schema or data change is approved for rollout. Do not use to choose the domain model, diagnose a query, or design the backup program.
Postgres query performance review
genaptic/skillsets/packs/shared/postgres-databases/skills/postgres-query-performance-review Skill
0★ repoDiagnose PostgreSQL statement latency using sanitized SQL, EXPLAIN evidence, cardinality, buffers, temp work, joins, statistics, waits, parameters, and representative experiments. Use when a query or workload is slow, unstable, or regressed. Do not use for greenfield schema design, broad schema audits, or choosing an index without statement-level evidence.
genaptic/skillsets/packs/shared/postgres-databases/skills/postgres-schema-design Skill
0★ repoDesign a new PostgreSQL schema from domain invariants and workloads, covering keys, types, nullability, constraints, relationships, tenancy, ownership, RLS, partitioning, index intent, and evolution. Use when creating or substantially reshaping a data model. Do not use for auditing an already deployed schema, diagnosing one slow query, or executing a production migration.
genaptic/skillsets/packs/shared/postgres-databases/skills/postgres-schema-review Skill
0★ repoAudit an existing PostgreSQL schema and deployed catalog state for integrity, ownership, privileges, search-path exposure, constraints, RLS, partitions, indexes, and operational drift. Use when reviewing current DDL, dumps, migrations, or catalog snapshots. Do not use for greenfield data modeling, one slow-query diagnosis, or applying remediation in production.
MukundaKatta/mcp-stack/io.github.MukundaKatta/sqlfmt-mcp MCP server
0★ repoDeterministic SQL formatting across 19 dialects (postgres, mysql, snowflake, bigquery, etc.).
xpaysh/mcp-server/io.github.xpaysh/web-scraping MCP server
0★ repo35+ web scraping tools. Firecrawl, Bright Data, Jina, Olostep, ScrapeGraph, Notte, Riveter.