database-optimization

database-optimization is an agent for Claude Code from davepoon/buildwithclaude. It costs 38 tokens per session (265 once invoked), scanned A, original, MIT.

A database performance assistant for SQL and NoSQL systems. It examines queries, schemas, indexes, connections, and monitoring data to find slow data access.

In plain words
What is it for?
Use it to analyze slow queries and execution plans, review schemas, design indexes, tune connection pools, and set up performance monitoring.
Why use it?
It helps explain database bottlenecks and choose targeted changes instead of adding indexes or resources without evidence.

Agent for Claude Code

Written for Claude Code: shipped in a Claude Code plugin.

Part of the agents-infrastructure-operations plugin — 8 agents shipped together

About the project

davepoon/buildwithclaude is a discovery hub and plugin marketplace for Claude Code extensions, including agents, commands, hooks, skills, plugins, MCP servers, and marketplace collections. Developers use it to browse, search, and find installation instructions for tools that extend Claude-related workflows. Catalogue entries include agents, plugins, commands, and skills from this collection.

davepoon/buildwithclaude · 3,419 stars · on GitHub · buildwithclaude.com

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/davepoon/buildwithclaude/database-optimization
Clone the repo
git clone --depth 1 https://github.com/davepoon/buildwithclaude

Made for: Claude Code.

Or install agents-infrastructure-operations, the plugin that ships this one along with the rest of its 8 agents.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for database-optimization

README.md
[![agentmods](https://agentmods.dev/badge/agents/davepoon/buildwithclaude/database-optimization.svg)](https://agentmods.dev/agents/davepoon/buildwithclaude/database-optimization)
Your own site
<a href="https://agentmods.dev/agents/davepoon/buildwithclaude/database-optimization"><img src="https://agentmods.dev/badge/agents/davepoon/buildwithclaude/database-optimization.svg" alt="Measured on agentmods" height="20"></a>
Per session 38 Only the description is in the session, so the agent can decide to use it. The body loads when it is invoked.
When invoked 265 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.1 $0.00038 $0.00265
Opus 5 $0.00019 $0.00133
Sonnet 5 $0.00008 $0.00053
Haiku 4.5 $0.00004 $0.00026

Measured 3d ago against content hash 3f8b4130fc76, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-06, from the pricing page.

Security

Grade A, and why

database-optimization 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 3d 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/agents-infrastructure-operations/agents/database-optimization.md · 30 lines

What it actually says

You are a Database Optimization specialist focusing on improving database performance, query efficiency, and overall data access patterns. Your expertise covers SQL optimization, NoSQL performance tuning, and database architecture best practices.

When invoked:

  • Analyze slow queries and identify performance bottlenecks
  • Design and review database schemas for optimal performance
  • Develop indexing strategies including B-tree, hash, and composite indexes
  • Configure connection pools and optimize transaction handling
  • Set up performance monitoring and query profiling systems

Process:

  1. Identify performance issues through query analysis and execution plans
  2. Optimize queries using proper joins, indexing, and query restructuring
  3. Design covering indexes and implement partitioning strategies
  4. Configure connection pooling with appropriate limits and timeouts
  5. Implement monitoring solutions for ongoing performance tracking
  6. Provide specific optimization recommendations with measurable metrics

Provide:

  • Optimized SQL queries with before/after performance comparisons
  • Index recommendations and implementation scripts
  • Connection pool configuration examples
  • Performance monitoring setup guidelines
  • Database architecture recommendations for scalability
  • Specific improvements with measurable performance metrics and reasoning
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. 3d ago First seen · 30 lines · 38 tokens per session scan A 3f8b4130fc76

Subscribe to this mod's changes

database-optimization is an agent published in the GitHub repository davepoon/buildwithclaude (3,419 stars, last pushed 2d ago), licensed MIT. It adds 38 tokens to every session and 265 once invoked, about $0.0002 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-09-03.

Related

Other agents, from other repositories

d1-debugger

Autonomous diagnostic agent that investigates Cloudflare D1 database issues through 9-phase analysis (config, migrations, queries, bindings, errors, limits, performance, Time Travel, report). Use when encountering D1 query errors, migration failures, binding issues, performance degradation, or limit/quota errors.

secondsky/claude-skills · 65 tokens

d1-query-optimizer

Performance analysis agent that identifies slow queries, missing indexes, and optimization opportunities in Cloudflare D1 databases using metrics, insights, and query plan analysis. Use when encountering slow queries, high latency, or performance degradation.

secondsky/claude-skills · 49 tokens

data-engineer

Data Engineer - Database schema changes and migrations.

bybren-llc/safe-agentic-workflow · 12 tokens

security-engineer

Security Engineer - RLS validation, security audits, vulnerability scanning.

bybren-llc/safe-agentic-workflow · 16 tokens

database-performance-optimizer

Use this agent when you need to optimize database performance for B2B applications at enterprise scale. This agent specializes in multi-tenant database optimization, query performance tuning, indexing strategies, connection pooling, and database scaling for SaaS platforms. Handles PostgreSQL, MySQL, MongoDB, and cloud…

xbim08/awesome-claude-code-plugins · 0 tokens

vector-database-engineer

Expert in vector databases, embedding strategies, and semantic search implementation. Masters Pinecone, Weaviate, Qdrant, Milvus, and pgvector for RAG applications, recommendation systems, and similarity search. Use PROACTIVELY for vector search implementation, embedding optimization, or semantic retrieval systems.

NOMARJ/sigil · 67 tokens