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

说明与用途

DBAdminer 是一个轻量级、只读的数据库浏览器，30 秒内启动，可嵌入 Go 项目，支持 Docker 运行，无需外部驱动。

问题

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

来源