Problem statement

OpenSRE currently lacks a first-class MariaDB integration. That limits investigation coverage for teams running MariaDB-backed services and troubleshooting connection issues, lock contention, slow queries, and database health incidents.

Proposed solution

Add a first-class MariaDB integration that supports:

• onboarding, authentication, and connectivity verification
• reading health, connections, locks, replication status, and slow-query context
• using MariaDB evidence directly during investigations and in final RCA output
• safe, targeted production-aware queries that avoid excessive data retrieval

Acceptance criteria

• the integration is usable from the investigation workflow end to end
• setup and usage are documented clearly
• the implementation is backed by end-to-end tests in tests/e2e or equivalent
• the PR includes a screen video showing setup plus a successful investigation flow using MariaDB
• vibecoding without testing will not be allowed; PRs without working end-to-end coverage and screen-video proof should be rejected