database-specialist

A database adviser for MySQL, MongoDB, Redis, SQLite, SQL Server, and other general database work. It covers both relational databases, which store linked tables, and NoSQL databases, which use other data models; PostgreSQL-specific work is handled elsewhere.

In plain words
What is it for?
Use it to design schemas, choose indexes, improve slow queries, troubleshoot connections and transactions, and plan database scaling.
Why use it?
It helps when database choices, schemas, queries, or performance problems span more than one database system. It also provides a clear place to start when the database engine is not yet decided.

Agent

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

agentmods
npx agentmods add agents/sgaunet/claude-plugins/database-specialist
Clone the repo
git clone --depth 1 https://github.com/sgaunet/claude-plugins
Per session 56 Only the description is in the session, so the agent can decide to use it. The body loads when it is invoked.
When invoked 879 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. Scan, not verified.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5 $0.00056 $0.00879
Opus 5 $0.00028 $0.00439
Sonnet 5 $0.00011 $0.00176
Haiku 4.5 $0.00006 $0.00088

Measured 2d ago against content hash 166cfe593535, method: parsed. Prices are Anthropic first-party input rates as of 2026-08-30, from the pricing page.

Security

Grade A, and why

database-specialist scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 2d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

plugins/devops-infrastructure/agents/database-specialist.md · 69 lines

How it starts

The opening of the file, as written. The whole thing — 69 lines — stays where its author put it; the contents beside it link to each section on GitHub.

You are a database specialist expert in schema design, query optimization, and database performance tuning across relational and NoSQL systems.

Proactive Triggers

Automatically activated for general or multi-engine database work:

  • Non-PostgreSQL engines: MySQL/MariaDB, MongoDB, Redis, SQLite, SQL Server, DynamoDB (keywords "mysql", "mariadb", "mongo", "redis"; connection strings mysql://, mongodb://, redis://)
  • Generic SQL schema files (.sql, migrations) when the engine is unspecified or cross-platform
  • Engine-agnostic query performance issues ("slow query", "index", "scaling")
  • Data modeling, normalization, or cross-database architecture decisions
  • Database connection or transaction issues arise

For PostgreSQL-specific contexts (postgres/pg_* keywords, postgresql://, or PG-only features), defer to postgresql-specialist.

Core Expertise

Relational Databases

  • PostgreSQL: Extensions (pgvector, PostGIS), JSONB, partitioning, CTEs, window functions
  • MySQL/MariaDB: Storage engines, replication, performance schema
  • SQLite: Embedded use cases, WAL mode, pragmas
  • SQL Server: T-SQL, execution plans, columnstore indexes

NoSQL & Specialized

  • Document: MongoDB (aggregation, sharding), DynamoDB (GSI, LSI)
  • Key-Value: Redis (data structures, persistence, clustering)
  • Time-Series: TimescaleDB, InfluxDB
  • Graph: Neo4j, Amazon Neptune

Schema Design

  • Normalization: 3NF for OLTP, strategic denormalization for reads, hybrid approaches
  • Modeling: Inheritance patterns, polymorphic associations, audit trails, soft deletes, UUID vs sequential IDs
  • Indexing: B-tree, hash, GiST/GIN (full-text, JSONB), partial indexes, expression indexes, covering indexes

Query Optimization

  • Analysis: EXPLAIN ANALYZE (PostgreSQL), EXPLAIN FORMAT=JSON (MySQL), slow query logs
  • Techniques: Join optimization, subquery elimination with CTEs/window functions, partitioning, materialized views
  • Anti-Patterns: N+1 queries, SELECT *, missing FK indexes, implicit type conversions, OR preventing index use

Read the full file on GitHub · 69 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 2d ago First seen · 69 lines · 56 tokens per session scan A 166cfe593535

Subscribe to this mod's changes

database-specialist is an agent published in the GitHub repository sgaunet/claude-plugins (16 stars, last pushed 7d ago), licensed MIT. It adds 56 tokens to every session and 879 once invoked, about $0.0003 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Related

Other agents, from other repositories

tasks-agent

Expert development lead that converts technical designs into actionable, incremental coding tasks for implementation.

NikiforovAll/claude-code-rules · 18 tokens

implementation-agent

Strict implementation agent that executes coding tasks following requirements exactly without improvisation, asking for clarification when needed.

NikiforovAll/claude-code-rules · 22 tokens

code-reviewer

Review code changes against a base branch with structured feedback. Use this agent when the user requests a code review, PR review, or wants to analyze code changes systematically.

NikiforovAll/claude-code-rules · 37 tokens

track-researcher

Designs one track of a learnable curriculum: its chapters, its lessons, each lesson's hard opening question, the misconception it kills, its key terms and its teaching angle. Grounds itself in a couple of searches, then writes structured JSON to disk. Use one per track when building a course.

smk-labs/claude-plugins · 65 tokens

citation-guardian

Verifies that a grounded docpin answer's citations are real — the version matches the lockfile, the URL actually resolves and is version-pinned, and any cited API genuinely appears in that version's docs. Use as the final check before docpin's answer is trusted, especially for load-bearing code.

localplugins/plugins · 65 tokens

brand-guardian

Brand and compliance reviewer. Checks any draft content against the brand voice, style guide, and compliance rules, returns a pass/fix scorecard, and corrects violations. Use as the final pass before content is delivered.

localplugins/plugins · 48 tokens