# SQL Editors

Dolt comes with a built-in MySQL compatible server, making it easy to connect to your Dolt databases with existing SQL tooling. Here are a list of notable MySQL Editors and our compatibility status.

| Editor                                                       | Supported | Notes and limitations                                         |
| ------------------------------------------------------------ | --------- | ------------------------------------------------------------- |
| [Tableplus](https://tableplus.com/)                          | ✅         | Recommended (see below)                                       |
| [Datagrip](https://www.jetbrains.com/datagrip/)              | ✅         | Potential information schema and backup compatibility issues. |
| [MySQL Workbench](https://www.mysql.com/products/workbench/) | ✅         | Potential information schema issues.                          |

If you experience any issues using the supported SQL editors above, please [file an issue on GitHub](https://github.com/dolthub/dolt/issues/new) so we can investigate and help.

## Setting up Dolt with Tableplus

[Tableplus](https://tableplus.com/) is the recommended SQL editor to use with Dolt. Let's clone a Dolt database and connect it to Tableplus. We have a [video](https://www.youtube.com/watch?v=0FkYraVqNjM) that walks through this experience as well.

### Step 1: Cloning a database.

Open your terminal and clone the following [database](https://www.dolthub.com/repositories/dolthub/ip-to-country/data/master).

```bash
dolt clone dolthub/ip-to-country && cd ip-to-country
```

Now run: `dolt sql -q 'show tables'` and you should see the following output

```bash
> dolt sql -q 'show tables'
+---------------+
| Table         |
+---------------+
| IPv4ToCountry |
| IPv6ToCountry |
+---------------+
```

### Step 2: Setting up your server

Dolt's sql server can be started with one command.

```bash
> dolt sql-server
Starting server with Config HP="0.0.0.0:3306"|U="root"|P=""|T="28800000"|R="false"|L="info"
```

The default configuration for our server uses a username of `root` and an empty password. You can configure access settings, logging, and timeouts by following additional documentation [here](https://docs.dolthub.com/reference/cli#dolt-sql-server).

### Step 3: Connecting our server with Tableplus

If you haven't already go ahead and install Tableplus from [here](https://tableplus.com/download):

Click on create a new connection:

![](https://1372377717-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MO3iUAEaFtCYE0joxfA%2Fuploads%2Fgit-blob-48760265eabfa1f7c91df7be6d557644b390a274%2Ftableplus-create-new-connection.png?alt=media\&token=35df9ce7-3ad5-4a52-b409-848b311f5a1e)

Hit MySQL in the selection box and fill in the following information. All the parameters are the same as for any MySQL database.

![](https://1372377717-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MO3iUAEaFtCYE0joxfA%2Fuploads%2Fgit-blob-1a54fe63e781ac5a95949c32d22a3eeea8d04bed%2Ftableplus-connect-info.png?alt=media)

When you hit `Test` you should see all the boxes turn green like in the above image. Finally, hit connect to access the Dolt server.

### Step 4: Writing queries with Tableplus

Let's start by selecting a database in the Dolt server and writing queries against it.

![](https://1372377717-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MO3iUAEaFtCYE0joxfA%2Fuploads%2Fgit-blob-516c3515dcd5691029a1f54079c4d35bb75932af%2Fselect-db-tableplus.png?alt=media)

Select the `ip_to_country` database. You should see tables populate to the left like below.

![](https://1372377717-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MO3iUAEaFtCYE0joxfA%2Fuploads%2Fgit-blob-4743ff805c6ccdac26b3cde0835bb27d8456c8c3%2Ftables-on-left-tableplus.png?alt=media)

Now click on the table `IPv4ToCountry` and see the screen populate. We just read from our Dolt database!

![](https://1372377717-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MO3iUAEaFtCYE0joxfA%2Fuploads%2Fgit-blob-1197bef34a4cce65b52a0f10c7f9c561fc967fcf%2Fopen-table-tableplus.png?alt=media)

Finally, let's write a quick query on the dataset. Click the `SQL` button in the top left and write the query in the box. Hit the `Run Current` button to execute it and the results should appear:

![](https://1372377717-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MO3iUAEaFtCYE0joxfA%2Fuploads%2Fgit-blob-597ce5ce8b2fb74fec34da9b0b22707d0575c478%2Frun-query-tableplus.png?alt=media)

That's it! You've successfully connected Dolt to Tableplus and ran your first query.

If you have any additional issues please file them [here](https://github.com/dolthub/dolt/issues).