Database Agent

Meet Tony. Your Database Engineer specialist agent.

Tony is the domain specialist for databases in the CloudThinker Multi-Agent System. He optimizes slow queries, manages schema drift, validates backups, and right-sizes capacity across PostgreSQL, MySQL, Redis, and beyond — keeping your data layer fast, safe, and efficient.

Tony, the CloudThinker Database Engineer specialist agent
Sub-skills

Leading use cases, customizable Skills

These are leading patterns customers run with Tony across data tiers — query optimization, schema, backup, replication, tuning, and capacity. They're starting points, not the limit — extend, replace, or add your own sub-skill with the Skills Framework.

/query-optimization

Slow Query Analysis

Identifies top-N slow queries from pg_stat_statements / performance_schema, proposes indexes and query rewrites, and validates impact on a read replica.

Top-N slow query analysis
Index + rewrite suggestions
Replica-validated impact

/schema-management

Migrations & Drift

Migration safety review (lock duration, blocking, rollback), drift detection between environments, and forward / backward compatibility checks.

Lock + blocking analysis
Env-to-env drift
Compatibility checks

/backup-recovery

Backup & PITR

Automated backup integrity checks, point-in-time recovery drills, and RTO / RPO measurement across primary, replica, and DR copies.

Backup integrity validation
PITR drills
RTO / RPO measurement

/replication-health

Replication & Failover

Replica lag monitoring, failover drill execution, and split-brain detection across PostgreSQL streaming, MySQL GTID, and Redis Cluster.

Replica lag thresholds
Failover drill automation
Split-brain detection

/performance-tuning

Tuning & Pooling

Autovacuum, work_mem, buffer pool, and connection-pool tuning based on workload signatures. PgBouncer / ProxySQL configuration review.

Autovacuum + work_mem
Connection pool tuning
Buffer pool sizing

/capacity-planning

Storage & Growth

Storage forecasts, table-and-index growth modeling, and partition strategy recommendations for hot tables before they impact latency.

Growth forecast modeling
Partition strategy
Hot-table identification
Workflow

From prompt to repeatable Command in three steps

Start with a prompt

Ask Tony in chat to investigate, tune, or validate. He executes a one-shot run inside Sandbox Isolation against a read replica, never the primary, and exports a SQL diff with replica-validated impact you can apply through your migration tool of choice.

@tony please find the top 10 slow queries on staging Postgres and propose indexes with replica-validated impact.

Persist as a Skill

Use /create-skill to capture the discovered surface, auth flow, Rules of Engagement, validation logic, and notification routing as a reusable Skill versioned in the Knowledge Base.

/create-skill optimize-postgres-queries
  --from-thread #current
  --scope staging-postgres
  --top 10
  --propose-patch sql,migration

Run anywhere as a Command

Invoke the saved Skill as a /-prefix Command from chat, webhook, or schedule. Re-runs are deterministic — same RoE, same surface, same CVE-mapped report.

/optimize-postgres-queries
Tony detects environment drift on each run and proposes a Skill update for human-approved merge — no manual maintenance.
Safety

Safe by construction — from sandbox to audit

Tony inherits the same platform primitives that protect every CloudThinker agent. Continuous database operations run against read replicas with strict scope, never mutating production data, and always with a tamper-evident audit trail.

Sandbox Isolation

Every run executes inside an ephemeral microVM with strict egress and a tamper-evident audit trail.

Per-run microVM
Egress allowlist
Auto-destroy on completion

Guardrails Engine

Guard-in and guard-out policy enforcement on every model call — PII / PHI redaction and secret detection by default.

PII / PHI redaction
Secret detection
Prompt-injection defense

Rules of Engagement

Strict scope, method, and rate-limit constraints. Read-only proof-of-concept execution. No destructive operations.

Scope allowlist
Read-only PoC
Pre-execution query filters

Immutable audit

Every reasoning step, tool call, and finding is recorded — exportable to your SIEM and reviewable by compliance.

Tamper-evident logs
SIEM-exportable
Replayable decisions

Compliance Certifications

We maintain the highest industry standards and regularly undergo rigorous third-party audits to ensure compliance.

Talk to Database Engineering

Ready to put Tony to work on your data layer?

Our database team partners directly with your platform, data, and SRE leads — slow-query reviews, migration safety audits, and PITR drill walkthroughs on request.

  • PostgreSQL / MySQL / Redis
  • Replica-validated PoC
  • Schema + Query + DR in one agent