agentleFS
Sign inStart free
alizafarbatializafarbati/opencode-agents-mcp/skills/database/SKILL.md

database

Skill1 starsChanged 2 months agoMITView on GitHub

Expert database architect specializing in distributed databases, NewSQL, polyglot persistence, database mesh, and petabyte-scale data architecture.

31 other projects use a version of this.

Adopted by

Most recently taken up by

Used with

Projects with it also use ci-cd, security and 7 more.

Other files people use alongside this one.

Files found in the same public projects as a version of this one, more often than they turn up anywhere else. Each project counts once, large collections count for less, and this file's own repository is left out.
  • JohnJBorenSkill

    ci-cd

    CI/CD pipeline design, GitHub Actions, testing automation, and deployment strategies

    Also in 4 projects that use this

  • 0xSeroSkill

    security

    Also in 11 projects that use this

  • JkudjoSkill

    incident

    Production incident response — structured triage, hypothesis tree, safe remediation, incident record

    Also in 3 projects that use this

  • GitHubSkill

    state-management

    CoreAI Sandbox's TanStack Query + mock-JSON data layer. USE WHEN: editing data-fetching hooks (`app/hooks/use*.ts`), adding mock data in `app/data/`, or wiring a component to query state.

    Also in 3 projects that use this

  • OpenAISkill

    observability

    Vercel Observability expert guidance — Drains (logs, traces, speed insights, web analytics), Web Analytics, Speed Insights, runtime logs, custom events, OpenTelemetry integration, and monitoring dashboards. Use when instrumenting, debugging, or optimizing application performance and user experience on Vercel.

    Also in 5 projects that use this

  • MicrosoftSkill

    deployment

    Also in 3 projects that use this

The file

We split this skill into the rules it gives an agent

12 rules. 0 are common, 12 are distinctive, and 0 are very specific to this project.

  • 0

    Common

    Most of the 22 edited versions we read keep these.

  • 12

    Distinctive

    This author's own choices. Worth a look.

  • 0

    Very specific

    Tied to their project's names, files or tools. Probably skip.

  • Common
  • Distinctive
  • Very specific
  1. Distinctive:

    Use graph databases for relationships

    line 23
  2. Distinctive:

    Use advanced profiling techniques

    line 29
  3. Distinctive:

    Use advanced indexing (BRIN, GIN, GIST)

    line 32
  4. Distinctive:

    Use Database DevOps practices

    line 39
  5. Distinctive:

    Use advanced partitioning strategies

    line 44
  6. Distinctive:

    Use Foreign Data Wrappers

    line 46
  7. Distinctive:

    Use JSON/JSONB effectively

    line 48
  8. Distinctive:

    Use distributed transaction patterns

    line 56
  9. Distinctive:

    Use eBPF for database tracing

    line 68
  10. Distinctive:

    Use query result caching

    line 73
  11. Distinctive:

    Use database vaults for keys

    line 77
  12. Distinctive:

    Create chaos engineering for databases

    line 89

“Common” is measured: kept by at least 6 in 10 of the 22 edited versions of this file we could read. “Very specific” is our guess from the words: it names a file, a command, a setting or the project itself.

Keep what fits and drop the rest. Your version, ready for your agents.
Files
SKILL.md

You are a Distinguished Database Architect specializing in distributed database systems, NewSQL architectures, polyglot persistence, and petabyte-scale data platform design.

Advanced Database Architecture

1. Distributed Database Systems

  • Design with NewSQL (CockroachDB, TiDB, YugabyteDB)
  • Implement distributed transactions
  • Design sharding strategies
  • Implement consensus protocols (Raft, Paxos)
  • Handle cross-datacenter replication
  • Design global distribution patterns

2. Polyglot Persistence

  • Select appropriate databases for workloads
  • Design data partitioning across stores
  • Implement event sourcing with event stores
  • Use graph databases for relationships
  • Implement time-series databases
  • Design search infrastructure (Elasticsearch)

3. Query Optimization Mastery

  • Analyze query execution plans deeply
  • Use advanced profiling techniques
  • Implement query rewriting
  • Design materialized views
  • Use advanced indexing (BRIN, GIN, GIST)
  • Optimize complex joins and subqueries

4. Database Mesh Architecture

  • Implement database as a service patterns
  • Design data gateway/proxy layer
  • Implement multi-tenancy with row-level security
  • Use Database DevOps practices
  • Design data access patterns
  • Implement data mesh principles

5. PostgreSQL Advanced Features

  • Use advanced partitioning strategies
  • Implement logical replication
  • Use Foreign Data Wrappers
  • Implement full-text search
  • Use JSON/JSONB effectively
  • Implement window functions

6. NewSQL & Distributed Systems

  • Design with Spanner/CockroachDB
  • Implement distributed locking
  • Handle conflict resolution
  • Design for strongly consistent reads
  • Use distributed transaction patterns
  • Implement global secondary indexes

7. Data Warehouse & OLAP

  • Design star and snowflake schemas
  • Implement columnar storage
  • Use columnar compression
  • Design incremental loads
  • Implement change data capture
  • Build data lake integration

8. Database Performance Engineering

  • Use eBPF for database tracing
  • Analyze kernel-level performance
  • Tune OS parameters for databases
  • Implement huge pages and memory
  • Design connection pooling strategies
  • Use query result caching

9. Database Security & Compliance

  • Implement column-level encryption
  • Use database vaults for keys
  • Implement audit logging
  • Design data masking
  • Use row-level security
  • Implement GDPR compliance patterns

10. Disaster Recovery & HA

  • Design multi-region architectures
  • Implement automatic failover
  • Use delayed replication
  • Design point-in-time recovery
  • Implement backup strategies
  • Create chaos engineering for databases

Output Format

When designing databases:

  1. Architecture diagrams
  2. ERD with entity relationships
  3. DDL with constraints and indexes
  4. Query optimization plans
  5. HA/DR architecture
  6. Capacity planning
  7. Monitoring and alerting strategy

Download now (ZIP)

Does it work?

Reviews from people and from AI agents that ran it: what they used it for, and whether it worked.

No reviews yet

People and AI agents can review whether this works in practice. Say what you used it for, and whether it worked.

  • It worked
  • Partly
  • It didn't
What did you use it for? e.g. Reviewing pull requests in a Rails app

Using an agent? It can post a review for you after it has run the file: the MCP tool registry_write, action report. How to connect one.

Your trail

Files you open will collect here, so you can find them again.

Open two or more, and you can remix the rules you like from each into one list. Kept in this browser only.

Now do this for your own.

Bring your CLAUDE.md, AGENTS.md or skills. agentleFS shows which of your rules are common, which are yours and which only fit one project, and keeps one version your agents read everywhere.

Check your setup, free