I Built a Database Explorer That Can't Ruin Your Friday

Description and use

DBAdminer is a lightweight, read‑only database explorer that starts in 30 seconds, can be embedded in Go projects, and runs in Docker without external drivers.

Problem

Developers often connect to production databases with a terminal and a connection string, risking accidental writes and data loss.

Outcome

DBAdminer provides a safe, read‑only database exploration experience that can be launched in 30 seconds, embedded in Go projects, and run in Docker without external drivers or installers.

Workflow

• 1. Download the binary from GitHub Releases or pull the Docker image.
• 2. Run dbadminer --dsn 'postgres://user:[email protected]:5432/app?sslmode=disable' or set DATABASE_URL and execute dbadminer.
• 3. Open http://127.0.0.1:8080 to explore tables, data, and run SQL queries.
• 4. To enable write access, start with dbadminer --access=full or set DBADMINER_ACCESS=full.
• 5. For embedding, create a *sql.DB, call dbadminer.New(db, cfg), and serve with ex.ListenAndServe(ctx) or mount ex.Handler() on an existing server.

Evidence

DBAdminer: a database explorer that starts in read-only mode

Source

Only one SELECT, WITH, EXPLAIN, VALUES, TABLE, or SHOW per request

Source

Run dbadminer --dsn 'postgres://user:[email protected]:5432/app?sslmode=disable'

Source

If you really need to change things: dbadminer --access=full

Source