Web based UI for managing and exploring SQL database data
1M+
DbGate web: https://www.dbgate.io
Live demo on: https://demo.dbgate.org
Source code on GitHub: https://github.com/dbgate/dbgate/
Pull the image from the Docker Hub Repository
docker pull dbgate/dbgate
Use the following command to start a container with DbGate
docker run -it --name dbgate-instance --restart always -p <port on host>:3000 dbgate/dbgate
If you want to preconfigure connections:
docker run -it --name dbgate-instance --restart always -p <port on host>:3000 -e CONNECTIONS='mssql' -e LABEL_mssql='MS SQL' -e SERVER_mssql='SERVER_IP' -e USER_mssql='USER' -e PASSWORD_mssql='PWD' -e ENGINE_mssql='mssql@dbgate-plugin-mssql' dbgate/dbgate
If you want to define connections in application, don't define CONNECTIONS environment variable. Instead, define volume mapping, so that saved connections are persisted. Volume mapping is needed also for persisting saved scripts, archives, application layers etc.
Or use following docker-compose fragment:
version: '3'
services:
dbgate:
image: dbgate/dbgate
restart: always
ports:
- 80:3000
volumes:
- dbgate-data:/root/.dbgate
environment:
CONNECTIONS: con1,con2,con3,con4
LABEL_con1: MySql
SERVER_con1: mysql
USER_con1: root
PASSWORD_con1: TEST
PORT_con1: 3306
ENGINE_con1: mysql@dbgate-plugin-mysql
LABEL_con2: Postgres
SERVER_con2: postgres
USER_con2: postgres
PASSWORD_con2: TEST
PORT_con2: 5432
ENGINE_con2: postgres@dbgate-plugin-postgres
LABEL_con3: MongoDB
URL_con3: mongodb://mongo:27017
ENGINE_con3: mongo@dbgate-plugin-mongo
LABEL_con4: SQLite
FILE_con4: /home/jan/feeds.sqlite
ENGINE_con4: sqlite@dbgate-plugin-sqlite
volumes:
dbgate-data:
driver: local
For complete list of available environment variable settings, please use documentation
Content type
Image
Digest
sha256:067ff4b06…
Size
104.1 MB
Last updated
3 days ago
Requires Docker Desktop 4.37.1 or later.