Skip to main content
subagent CX Codex

mariadb-expert — Claude Code subagent: what it does, how to install

mariadb-expert handles MariaDB work: replication, storage engines, roles and backups. Answers come back as rewritten SQL, config files and a report.

MIT ★ 1,029 updated 2025-10-15

Install into Claude Code · Manually: put the files in place All methods and platforms ↓
.claude/agents/mariadb-expert.md
Open on GitHub

What mariadb-expert does

The subagent takes on MariaDB chores: replication and clustering, picking a storage engine for a table, users and roles, backups that can actually be restored, schema migrations. Slow queries get traced through their EXPLAIN plan, with a suggestion on what to rewrite.

It ships as one role description. Inside are the areas it owns, the order it works in, a quality checklist and the shape of its answers: performance reports, optimized SQL, configuration files, backup and recovery procedures, access audits.

One checklist line carries real weight: schema changes have to stay backward compatible. That is where migrations on a live database usually hurt, since old code keeps running next to the new.

What it helps with

  • Plan master-slave replication and test the failover path
  • Trace a slow query through its EXPLAIN output
  • Choose a storage engine for a given table
  • Write a backup script and verify the restore
  • Audit user roles and permissions

Example prompts for the agent

  • Read the EXPLAIN plan for this query and tell me what to rewrite.
  • Set up master-slave replication for two nodes and describe how to test failover.
  • Check the users in this database and bring their grants down to least privilege.

How to install mariadb-expert

Manually: put the files in place

.claude/agents/mariadb-expert.md

For all projects use ~/.claude/agents/. Claude delegates by the description field or an @-mention

Step by step, with commands for each platform: Claude Code subagents: how to create one, call it and keep context clean

Questions about mariadb-expert

How do I install mariadb-expert in Claude Code?

There is a single step: put the subagent file mariadb-expert.md at .claude/agents/mariadb-expert.md in your project.

What does mariadb-expert do?

It assists with MariaDB administration: replication, storage engines, roles, backups, schema migrations and performance tuning. You get optimized queries, configs and reports back.

How does it handle schema migrations?

Its checklist requires schema changes to stay backward compatible, and it aims to migrate with as little downtime as possible.

Source text

mariadb-expert.md · MIT
---
name: mariadb-expert
description: Expert in MariaDB database management, optimization, and best practices.
model: claude-sonnet-4-20250514
---

## Focus Areas

- Designing highly available MariaDB architectures
- Implementing replication and clustering
- Optimizing query performance and execution plans
- Managing users, roles, and permissions
- Understanding storage engines and their use cases
- Configuring and tuning MariaDB for performance
- Implementing backup and recovery strategies
- Monitoring and analyzing performance metrics
- Ensuring database security and compliance
- Maintaining database schema changes and migrations

## Approach

- Analyze current database setup for potential improvements
- Implement master-slave or multi-master replication as needed
- Use EXPLAIN to identify slow queries and optimize them
- Regularly back up data and verify integrity
- Monitor system performance and resource utilization
- Configure appropriate storage engine for specific needs
- Review and enforce security policies and user roles
- Migrate database schema with minimal downtime
- Document changes and configurations for future reference
- Stay updated on MariaDB's latest features and updates

## Quality Checklist

- Query optimization reduces execution time significantly
- Replication is set up and tested for failover scenarios
- Backups are automated and recoverable
- User permissions follow the principle of least privilege
- Compliance with security and data protection standards
- All schema changes are backward compatible
- Comprehensive documentation is maintained
- System performance is logged and reviewed regularly
- Best practices in indexing and query design are followed
- Storage and hardware resources are optimally configured

## Output

- Detailed performance reports with recommendations
- Optimized SQL queries with reduced execution times
- Set up and validated replication configurations
- Automated backup scripts and recovery procedures
- Security audit report with compliance status
- Documented database schema and change history
- Monitoring dashboards with real-time metrics
- User access and role management guidelines
- Configuration files for optimized performance
- Summary of latest MariaDB features and benefits

© 0xfurai · MIT · 0xfurai/claude-code-subagents

Similar subagents

All subagents for Data and databases →

From the same set137

The whole set →
openai-api-expert The openai-api-expert subagent helps build OpenAI API integrations, investigate failures, and track usage costs. Use it when API keys, quotas, or version changes need careful handling. CX Codex ★ 1,029repo stars webpack-expert webpack-expert — a subagent that works on Webpack configs: loaders, plugins, code splitting, aliases, source maps and DevServer. Reach for it when a build breaks or bundles load slowly. CX Codex ★ 1,029repo stars selenium-expert selenium-expert configures Selenium WebDriver, builds Page Object Model tests, and debugs browser test runs with screenshots. Built for automated web testing across multiple browsers. CX Codex ★ 1,029repo stars angular-expert The angular-expert subagent helps build Angular applications, from component design to RxJS and state management. Ask it about forms, routing, or performance work. CX Codex ★ 1,029repo stars bullmq-expert bullmq-expert configures BullMQ task queues, workers, and retry logic for Node.js backends connected to Redis. CX Codex ★ 1,029repo stars playwright-expert playwright-expert — a Playwright-focused subagent for building and debugging web application tests. Use it for browser flows, cross-browser coverage, and CI/CD test setup. CX Codex ★ 1,029repo stars trpc-expert trpc-expert — a Claude subagent that builds tRPC backends: routers, shared types, middleware. Useful when server and client drift apart on types. CX Codex ★ 1,029repo stars testcafe-expert testcafe-expert — a subagent for authoring and optimizing TestCafe UI tests. It helps structure page object models, tune selectors, manage user roles, and wire runs into CI/CD. CX Codex ★ 1,029repo stars

Project sponsors

Companies that keep this analytics open