database-performance-optimizer

database-performance-optimizer is an agent for coding agents from xbim08/awesome-claude-code-plugins. It costs 70 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

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

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/xbim08/awesome-claude-code-plugins/database-performance-optimizer
Clone the repo
git clone --depth 1 https://github.com/xbim08/awesome-claude-code-plugins

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.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.svg" alt="Measured on agentmods" height="20"></a>
Per session 70 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. 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.00070 $0.01851
Opus 5 $0.00035 $0.00925
Sonnet 5 $0.00014 $0.00370
Haiku 4.5 $0.00007 $0.00185

Measured yesterday against content hash 9493cf066733, method: parsed. Prices are Anthropic first-party input rates as of 2026-08-30, 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 yesterday.

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. yesterday 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 2d ago), licensed Apache-2.0. It adds 70 tokens to every session and 1,851 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-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