Skip to content
dbtuneup
Get started
What we do

Database services, end to end.

Pick a single engagement or stack them — every service ends with measurable before/after numbers and a documented rollback path.

dbtuneup services overview
Service 01

Performance audit

A focused read of your slow-query log, EXPLAIN plans, and missing indexes — turned into a punch list of the highest-impact fixes.

Output
PDF report + ranked fix list
Duration
24–48 hours

What's included

  • Slow-query log + pg_stat_statements / MySQLTuner analysis
  • EXPLAIN ANALYZE walkthrough on the top N queries
  • Index health report (dead, missing, duplicate, redundant)
  • PDF audit summary you can share with stakeholders
Read more See pricing
Service 02

Index & query optimization

We rebuild your index strategy on a staging copy, rewrite the worst offenders, and verify with before/after benchmarks.

Output
Apply + rollback SQL, benchmarks
Duration
2–3 business days

What's included

  • Composite + covering indexes, B-tree vs GIN/GiST trade-offs
  • Query rewrites (subquery → JOIN, CTEs, window functions)
  • Dead-index removal with replication-safe rollout
  • Before / after benchmark report on production-shaped data
Read more See pricing
Service 03

Database migration

Single-engine upgrades or full cross-engine migrations using pgloader, AWS DMS, or custom ETL pipelines — with a verified cutover.

Output
Migrated DB, runbook, rollback
Duration
3–10 business days

What's included

  • Schema dump, sanitised replay on staging
  • Cross-engine type & FK mapping (MySQL ↔ Postgres, SQL → Mongo)
  • Logical replication / dual-write cutover under 5 minutes
  • Backup + rollback scripts, post-migration smoke tests
Read more See pricing
Service 04

Schema review & normalization

A senior pair-of-eyes on your schema — flagging accidental N+1 designs, denormalisation that hurt you, and modelling that won't scale.

Output
Schema diff + ADR document
Duration
3–5 business days

What's included

  • Entity-relationship review with growth assumptions
  • Hot-table normalization / partitioning recommendations
  • Foreign key + constraint hygiene check
  • Migration plan to reach the recommended end state
Read more See pricing
Service 05

Rollback & recovery hardening

For teams that want to ship database changes faster — we audit your backup, PITR, and rollback story and harden the gaps.

Output
Validated runbook + tested restore
Duration
3–5 business days

What's included

  • Backup + PITR validation (we restore it on a test cluster)
  • Migration rollback patterns + tooling
  • Disaster recovery runbook with RTO / RPO targets
  • On-call playbook for the most likely failure modes
Read more See pricing
Service 06

Enterprise tune-up

Everything: deep audit, query rewrites, schema review, migration where needed, plus a 30-day post-deploy review window.

Output
Comprehensive engagement package
Duration
2–4 weeks

What's included

  • pgBadger / MySQLTuner deep audit + workload profiling
  • Query rewrites, schema review, and selective migration
  • Priority chat support throughout the engagement
  • 30-day follow-up review with executive PDF
Read more See pricing

Not sure which service fits?

Send us a paragraph about what's slow. We'll point you at the right plan within an hour.

Talk to an engineer Compare plans