A simple and quick overview of your PostgreSQL database — built for DBAs, developers, and the curious.
Running a PostgreSQL database usually means juggling between psql, pgAdmin, Datadog, and a handful of home-grown scripts.
Dumb0 brings the essentials together in a lightweight, local web application: a clear dashboard to visualize the
state of your database at a glance, understand what's happening under the hood.
No cloud, no account to create, no data leaving your server. You connect your database, and that's it.
Designed for those who want a simple and quick overview of their database — no bloat, no overkill.
Right after connecting, a full panorama of your database:
- Key counters: number of tables, number of indexes, total size, shared buffers
- List of active connections (user, application, IP, start date) with the ability to disconnect a session
- Real-time locks tracking, with a visual alert when locks are blocking the database
- Automatic detection of the
pg_stat_statementsextension to know whether fine-grained query analysis is available
Dive into each table individually:
- Size: total, data, and index
- Row statistics (insertions, updates, deletions, scans)
- I/O statistics: sequential scans vs index scans, blocks read from disk vs cache
- Indexes: definition of every index on the table
- Locks specific to the table
A full-featured editor, powered by Monaco (the engine behind VS Code):
- Syntax highlighting, autocompletion, multi-cursor
- Execute queries with timing and row count
- History of executed queries
- Save and reuse your favorite queries
- Built-in guardrail: potentially destructive queries are blocked before execution
- Copy results in one click
A helping hand from AI to understand and optimize your queries:
- Query analysis: explanation, points of attention, optimization suggestions
- Contextual index suggestions, based on the tables actually queried
- Clean Markdown rendering of the answers, right inside the app
- Powered by Mistral AI — just set your API key in the settings
- Automatic and configurable refresh of indicators (custom interval)
- Real-time visual indicator of the refresh status
- Ideal for monitoring a database continuously without clicking "Reload"
- Connect multiple PostgreSQL databases and switch between them instantly
- Connections stored locally (embedded SQLite database) — your credentials never leave your machine
- Duplicate, edit, and delete your connections in a few clicks
- Docker
- An accessible PostgreSQL database
docker run -d --name dumb0-container -p 3000:3000 -p 80:80 \
--add-host host.docker.internal:host-gateway \
-v dumb0-data:/srv/dumb0/data \
thomasleconte/dumb0:latestversion: '3.8'
services:
dumb0:
image: thomasleconte/dumb0:latest
container_name: dumb0-container
ports:
- "3000:3000"
- "80:80"
extra_hosts:
- "host.docker.internal:host-gateway"
volumes:
- dumb0-data:/srv/dumb0/data
restart: always
volumes:
dumb0-data:The app is then available at http://localhost (frontend) and the API at http://localhost:3000.
Note on PostgreSQL host: the flag
--add-host host.docker.internal:host-gatewaylets the container reach a PostgreSQL instance running on your host machine viahost.docker.internal. If your database runs elsewhere, use its hostname or IP address instead.
The embedded SQLite database (datasources, query history, saved queries, settings) live in /srv/dumb0/data inside the container.
The commands above mount a named Docker volume (dumb0-data), so your data survives container recreation and image upgrades. Deleting the volume (docker volume rm dumb0-data) wipes the data.
Use a folder on your machine instead of a named volume
Replace dumb0-data:/srv/dumb0/data with an absolute path to a folder on your host:
# Docker CLI
docker run -d --name dumb0-container -p 3000:3000 -p 80:80 \
--add-host host.docker.internal:host-gateway \
-v /absolute/path/on/your/machine:/srv/dumb0/data \
thomasleconte/dumb0:latest# Docker compose
volumes:
- /absolute/path/on/your/machine:/srv/dumb0/dataThe folder does not need to exist beforehand — Docker creates it (as root on Linux). On first start the app writes app.db and key.bin inside it. You can then back up the folder directly, since the SQLite database is a single file. Note: the path must be absolute; a relative path would be interpreted as a named volume.
| Area | Technology |
|---|---|
| Backend | ExpressJS, NodeJS v24.18 |
| Frontend | Vue 3 + TypeScript |
| UI | PrimeVue, Tailwind CSS |
| SQL editor | Monaco Editor |
| Local database | SQLite (node:sqlite) |
| AI | Mistral AI |
Contributions are welcome! Fork the repository, create a branch, and open a pull request.
You first need to get a free Community licence key from PrimeUI which owns Primevue, check this link!
If you want to run project, you will have to define a .env file in src/front folder. Then, launch back & front, and have fun!
Set the PrimeUI licence key in an environment variable with your terminal. Use this same terminal to launch following command :
docker build -f src/Dockerfile -t dumb0-image --build-arg VITE_PRIMEVUE_LICENCE_KEY=$VITE_PRIMEVUE_LICENCE_KEY .docker run --name dumb0-test -p 3000:3000 -p 80:80 \
--add-host host.docker.internal:host-gateway \
-v dumb0-data:/srv/dumb0/data \
dumb0-imageDistributed under the MIT license. See the LICENSE file.