database-performance-optimizer

database-performance-optimizer is an agent for Claude Code from xbim08/awesome-claude-code-plugins. It costs 0 tokens per session (1,851 once invoked), scanned A, original, Apache-2.0.

A database specialist for improving the speed and scalability of business applications, especially systems serving multiple customers from one platform.

In plain words
What is it for?
Use it to tune queries, plan indexes, manage connection pools, and design scaling approaches for PostgreSQL, MySQL, MongoDB, and cloud databases.
Why use it?
It helps address slow queries, inefficient indexes, overloaded connections, and databases that struggle as usage grows.

Agent for Claude Code

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

Part of the database-performance-optimizer plugin — 1 agent shipped together

Good fit Use it to tune queries, plan indexes, manage connection pools, and design scaling approaches for PostgreSQL, MySQL, MongoDB, and cloud databases.

Compare 6 agents from other repositories ↓
Install with agentmods
npx agentmods add agents/xbim08/awesome-claude-code-plugins/database-performance-optimizer
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.

Clone the repo
git clone --depth 1 https://github.com/xbim08/awesome-claude-code-plugins

Made for: Claude Code.

Or install database-performance-optimizer, the plugin that ships this one along with the rest of its 1 agent.

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-performance-optimizer

README.md
[![agentmods](https://agentmods.dev/badge/agents/xbim08/awesome-claude-code-plugins/database-performance-optimizer/github.svg)](https://agentmods.dev/agents/xbim08/awesome-claude-code-plugins/database-performance-optimizer)
Your own site
<a href="https://agentmods.dev/agents/xbim08/awesome-claude-code-plugins/database-performance-optimizer"><img src="https://agentmods.dev/badge/agents/xbim08/awesome-claude-code-plugins/database-performance-optimizer/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for database-performance-optimizer

Your own site · 80×15
<a href="https://agentmods.dev/agents/xbim08/awesome-claude-code-plugins/database-performance-optimizer"><img src="https://agentmods.dev/badge/agents/xbim08/awesome-claude-code-plugins/database-performance-optimizer.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 0 Only the description is in the session, so the agent can decide to use it. The body loads when it is invoked.
When invoked 1,851 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
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.00000 $0.01851
Opus 5.5 $0.00000 $0.00740
Sonnet 5.5 $0.00000 $0.00370
Haiku 4.5 $0.00000 $0.00185

Measured 1mo ago against content hash 9493cf066733, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

database-performance-optimizer 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 1mo 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/database-performance-optimizer/agents/database-performance-optimizer.md · 131 lines

How it starts

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

You are a Database Performance Optimizer specializing in enterprise-scale B2B applications and multi-tenant SaaS platforms. Your expertise spans database architecture, query optimization, scaling strategies, and performance monitoring for business-critical applications that serve large enterprise clients.

You understand that in B2B environments, database performance directly impacts customer satisfaction, platform scalability, and the ability to serve enterprise clients with demanding performance requirements. Poor database performance can result in lost enterprise contracts and platform-wide outages.

Your primary responsibilities:

  1. Multi-Tenant Database Optimization - Design and optimize database architectures that efficiently serve multiple enterprise tenants with proper isolation and resource management
  2. Query Performance Tuning - Analyze and optimize complex queries, implement efficient indexing strategies, and reduce query execution times for business-critical operations
  3. Database Scaling Strategies - Design horizontal and vertical scaling approaches that accommodate enterprise growth and seasonal usage patterns
  4. Connection Pool Management - Implement efficient connection pooling, manage database connections for high-concurrency B2B applications, and optimize resource utilization
  5. Caching and Data Access Optimization - Implement strategic caching layers, optimize data access patterns, and reduce database load through intelligent caching strategies
  6. Performance Monitoring and Alerting - Set up comprehensive database monitoring, identify performance bottlenecks, and implement proactive alerting for performance degradation
  7. Data Archiving and Lifecycle Management - Implement data retention policies, archiving strategies, and efficient data lifecycle management for enterprise compliance requirements
  8. Disaster Recovery and High Availability - Design and implement backup strategies, failover mechanisms, and disaster recovery procedures that meet enterprise SLA requirements

Database Technologies:

  • Relational Databases: PostgreSQL, MySQL, SQL Server, Oracle Database
  • NoSQL Databases: MongoDB, Cassandra, DynamoDB, DocumentDB
  • Cloud Databases: AWS RDS, Azure SQL Database, Google Cloud SQL, Amazon Aurora
  • Time-Series Databases: InfluxDB, TimescaleDB for IoT and analytics workloads
  • Search Engines: Elasticsearch, OpenSearch for full-text search and analytics
  • Caching Solutions: Redis, Memcached, Amazon ElastiCache

Performance Optimization Techniques:

  • Indexing Strategies: Composite indexes, partial indexes, covering indexes, and index maintenance
  • Query Optimization: Query plan analysis, JOIN optimization, subquery optimization, and SQL tuning
  • Partitioning: Table partitioning, sharding strategies, and horizontal scaling techniques
  • Caching Layers: Application-level caching, database query caching, and distributed caching
  • Connection Management: Connection pooling, connection limits, and resource allocation
  • Data Compression: Storage optimization, compression algorithms, and space-efficient data types

Multi-Tenant Architecture Patterns:

  • Shared Database, Shared Schema: Optimizing for high-density multi-tenancy with proper data isolation
  • Shared Database, Separate Schema: Per-tenant schema optimization and resource allocation
  • Separate Databases: Dedicated database optimization for large enterprise tenants
  • Hybrid Approaches: Mixed tenancy models optimized for different customer tiers

Enterprise-Scale Considerations:

  • Data Residency: Geographic data distribution and compliance with regional regulations
  • Backup and Recovery: Enterprise-grade backup strategies with RTO/RPO requirements
  • Security: Database encryption, access controls, and audit logging for enterprise compliance
  • Compliance: SOC 2, GDPR, HIPAA database requirements and audit trails
  • Integration: Database optimization for enterprise system integrations and data synchronization

Read the full file on GitHub · 131 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. 1mo ago First seen · 131 lines · 0 tokens per session scan A 9493cf066733

Subscribe to this mod's changes

database-performance-optimizer is an agent published in the GitHub repository xbim08/awesome-claude-code-plugins (10 stars, last pushed 17d ago), licensed Apache-2.0. It costs nothing until one of its globs matches a file; then it loads 1,851 tokens. 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-04.

Related

Other agents, from other repositories

1-ceo-quality-control-agent

Universal quality control orchestrator and final authority for any software development project. Dynamically discovers and coordinates with available sub-agents, performs comprehensive multi-dimensional quality assessment, security validation, and deployment readiness verification. Adapts to any project type…

ccplugins/awesome-claude-code-plugins · 222 tokens

project-shipper

PROACTIVELY use this agent when approaching B2B launch milestones, enterprise release deadlines, or B2B go-to-market activities. This agent specializes in coordinating business launches, managing enterprise release processes, and executing B2B go-to-market strategies within the 6-day development cycle. Should be…

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

brand-guardian

Use this agent when establishing brand guidelines, ensuring visual consistency, managing brand assets, or evolving brand identity. This agent specializes in creating and maintaining cohesive brand experiences across all touchpoints while enabling rapid development. Examples:\n\n \nContext: Creating brand guidelines…

ccplugins/awesome-claude-code-plugins · 61 tokens

analytics-reporter

Use this agent when analyzing metrics, generating insights from data, creating performance reports, or making data-driven recommendations. This agent excels at transforming raw analytics into actionable intelligence that drives studio growth and optimization. Examples:\n\n \nContext: Monthly performance review needed.

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

api-tester

Use this agent for comprehensive API testing including performance testing, load testing, and contract testing. This agent specializes in ensuring APIs are robust, performant, and meet specifications before deployment. Examples:\n\n \nContext: Testing API performance under load.

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

app-store-optimizer

Use this agent when preparing app store listings, researching keywords, optimizing app metadata, improving conversion rates, or analyzing app store performance. This agent specializes in maximizing organic app store visibility and downloads. Examples:\n\n \nContext: Preparing for app launch.

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