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

Описание и применение

DBAdminer – легкий инструмент для безопасного просмотра баз данных, запускается за 30 секунд и может быть встроен в Go‑приложения.

Задача

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

Результат

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.

Рабочий процесс

• 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.

Доказательства

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

Источник

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

Источник

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

Источник

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

Источник