# Database Optimization Tool

Database Optimization Tool is a PostgreSQL builder and review tool for small teams.

## What It Does
- Collects PostgreSQL performance statistics locally and exports JSON.
- Guides new teams through structured PostgreSQL schema drafts before a live database exists.
- Audits slow queries, missing index candidates, unused index candidates, write amplification risk, stale statistics, table bloat signals, autovacuum drift, temp writes, and scan-heavy tables.
- Uses deterministic rules and Evidence Gate so AI claims without PostgreSQL evidence do not become official findings.
- Provides an AI Upgrade Lab advisory as plain text, separate from evidence-gated findings.
- Does not require write access to production databases.
- Gives new verified members one month of member credits before paid weekly access.

## Main Pages
- Home: https://databaseoptimizationtool.com/
- FAQ section: https://databaseoptimizationtool.com/#faq
- Ways to start section: https://databaseoptimizationtool.com/#ways-to-start
- How optimization works: https://databaseoptimizationtool.com/how-optimization-works - collect, classify, recommend, validate, evidence levels, and the postgresaudit public toolkit boundary.

## Product App Pages
- Pricing: https://databaseoptimizationtool.com/pricing
- Database chooser: https://databaseoptimizationtool.com/database-chooser - compare common database types and choose a project path.
- Updates: https://databaseoptimizationtool.com/updates - product updates, repair logs, release notes, and public QA evidence.
- SQL optimization workbench: https://databaseoptimizationtool.com/sql-optimization - turn slow SQL, schema, EXPLAIN, and evidence into a reviewable optimization report.
- Schema builder: https://databaseoptimizationtool.com/schema-builder
- Sample project: https://databaseoptimizationtool.com/sample-project - complete public project flow from schema draft to review-ready output.
- Sample report: https://databaseoptimizationtool.com/sample-report
- Product read-only collector: https://databaseoptimizationtool.com/docs/collector - collect audit.json, validate it locally, and generate handoff.md.
- Local companion CLI: https://databaseoptimizationtool.com/docs/local-companion - postgresaudit collect, validate, and handoff workflow.
- postgresaudit public toolkit: https://github.com/daanaagua/postgresaudit - read-only CLI, synthetic examples, schemas, permissions, privacy guidance, and tests.
- PostgreSQL optimization audit: https://databaseoptimizationtool.com/postgresql-optimization-audit
- PostgreSQL index audit: https://databaseoptimizationtool.com/postgresql-index-audit
- pg_stat_statements audit: https://databaseoptimizationtool.com/pg-stat-statements-audit
- Postgres table bloat check: https://databaseoptimizationtool.com/postgres-table-bloat-check
- Postgres query performance audit: https://databaseoptimizationtool.com/postgres-query-performance-audit
- Postgres index health check: https://databaseoptimizationtool.com/postgres-index-health-check
- Postgres maintenance audit: https://databaseoptimizationtool.com/postgres-maintenance-audit
- Postgres slow query audit: https://databaseoptimizationtool.com/postgres-slow-query-audit
- Postgres missing index check: https://databaseoptimizationtool.com/postgres-missing-index-check
- Postgres sequential scan audit: https://databaseoptimizationtool.com/postgres-sequential-scan-audit
- Postgres unused index check: https://databaseoptimizationtool.com/postgres-unused-index-check
- Postgres temp writes check: https://databaseoptimizationtool.com/postgres-temp-writes-check
- Postgres write amplification check: https://databaseoptimizationtool.com/postgres-write-amplification-check
- Postgres autovacuum health check: https://databaseoptimizationtool.com/postgres-autovacuum-health-check
- Postgres dead rows check: https://databaseoptimizationtool.com/postgres-dead-rows-check
- Postgres vacuum analyze check: https://databaseoptimizationtool.com/postgres-vacuum-analyze-check
- Postgres stale statistics check: https://databaseoptimizationtool.com/postgres-stale-statistics-check
- Postgres work_mem check: https://databaseoptimizationtool.com/postgres-work-mem-check
- Managed Postgres audit hub: https://databaseoptimizationtool.com/managed-postgres-audit
- Supabase Postgres audit: https://databaseoptimizationtool.com/managed-postgres-audit/supabase
- Neon Postgres audit: https://databaseoptimizationtool.com/managed-postgres-audit/neon
- AWS RDS Postgres audit: https://databaseoptimizationtool.com/managed-postgres-audit/aws-rds
- Cloud SQL Postgres audit: https://databaseoptimizationtool.com/managed-postgres-audit/cloud-sql
- Read-only user Postgres audit: https://databaseoptimizationtool.com/managed-postgres-audit/readonly-user
- Postgres audit without superuser: https://databaseoptimizationtool.com/managed-postgres-audit/without-superuser
- pg_stat_statements disabled audit: https://databaseoptimizationtool.com/managed-postgres-audit/pg-stat-statements-disabled

## Pricing
- Monthly plan: $24 per month.
- Yearly plan: $228 per year.
- New verified members receive one month of member credits before choosing a paid plan.
- Paid plans keep schema drafting and live database review in one account workspace.

## Safety Position
Database Optimization Tool is review-first. It can recommend read-only diagnostics, EXPLAIN analysis, staging tests, and rollback planning. It does not execute production optimization SQL.