Editors
Dolt comes with a built in MySQL compatible server that you can connect SQL Editors too. Here are a list of notable MySQL Editors and our compatibilty status.
Editor
Supported
Notes and limitations
Tableplus
Dbeaver
Datagrip
Need to implement a couple functions
Missing some information schema materials

Config Customization

Some editors require custom configuration of dolt's sql-server. For example, DBeaver use multiple connections to run queries whereas dolt sql-server supports 1 connection out of the box. Here's a sample config file that should get you started with dolt sql-server
1
2
3
4
log_level: trace
5
6
behavior:
7
read_only: false
8
autocommit: true
9
10
user:
11
name: root
12
password: ""
13
14
listener:
15
host: localhost
16
port: 3306
17
max_connections: 10
18
read_timeout_millis: 28800000
19
write_timeout_millis: 28800000
20
Copied!
NOTE: Dolt does not support SSL yet, so be sure to turn it off on your editor before connecting.
You can see this section to learn more about each part of our config file.
If there are other editors that you want us to be compatible with please do not hesitate to reach out!
Last modified 2mo ago
Export as PDF
Copy link