LogoLogo
DoltHubBlogDiscordGitHubDolt
  • Introduction
    • What Is Dolt?
    • Installation
      • Linux
      • Windows
      • Mac
      • Build from Source
      • Application Server
      • Docker
      • Upgrading
    • Getting Started
      • Version Controlled Database
      • Git For Data
      • Versioned MySQL Replica
    • Use Cases
      • Data Sharing
      • Data and Model Quality Control
      • Manual Data Curation
      • Version Control for your Application
      • Versioned MySQL Replica
      • Audit
      • Configuration Management
      • Offline First
  • Concepts
    • Dolt
      • Git
        • Commits
        • Log
        • Diff
        • Branch
        • Merge
        • Conflicts
        • Remotes
        • Working Set
      • SQL
        • Databases
        • Schema
        • Tables
        • Primary Keys
        • Types
        • Indexes
        • Views
        • Constraints
        • Triggers
        • Procedures
        • Users/Grants
        • Transactions
        • System Variables
      • RDBMS
        • Server
        • Backups
        • Replication
    • DoltHub/DoltLab
      • Permissions
      • Pull Requests
      • Issues
      • Forks
  • SQL Reference
    • Running the Server
      • Configuration
      • Access Management
      • Branch Permissions
      • Backups
      • Garbage Collection
      • Metrics
      • Replication
      • Troubleshooting
    • Version Control Features
      • Using Branches
      • Merges
      • Querying History
      • Using Remotes
      • Procedures
      • Functions
      • System Tables
      • System Variables
      • Saved Queries
    • SQL Language Support
      • Data Description
      • Expressions, Functions, Operators
      • Supported Statements
      • MySQL Information Schema
      • Collations and Character Sets
      • System Variables
      • Miscellaneous
    • Supported Clients
      • Programmatic
      • SQL Editors
    • Benchmarks and Metrics
      • Correctness
      • Latency
      • Import
  • CLI Reference
    • Commands
    • Git Comparison
  • Architecture
    • Overview
    • Storage Engine
      • Commit Graph
      • Prolly Trees
      • Block Store
    • SQL
      • Go MySQL Server
      • Vitess
  • Guides
    • Cheat Sheet
    • Contributing
      • dolt
      • go-mysql-server
    • MySQL to Dolt Replication
    • Importing Data
    • Integrations
  • Other
    • FAQ
    • Roadmap
    • Versioning
  • Products
    • Hosted Dolt
      • Getting Started
      • Notable Features
      • SQL Workbench
      • Cloning a Hosted Database
      • Using DoltHub as a Remote
      • Infrastructure
    • DoltHub
      • Data Sharing
      • API
        • Authentication
        • SQL
        • CSV
        • Database
        • Hooks
      • Continuous Integration
        • Getting Started
        • Workflow Reference
      • Transform File Uploads
      • Workspaces
    • DoltLab
    • Dolt Workbench
    • DoltgreSQL
Powered by GitBook
On this page
  • Setting up Dolt with Tableplus
  • Step 1: Cloning a database.
  • Step 2: Setting up your server
  • Step 3: Connecting our server with Tableplus
  • Step 4: Writing queries with Tableplus

Was this helpful?

Edit on GitHub
Export as PDF
  1. SQL Reference
  2. Supported Clients

SQL Editors

PreviousProgrammaticNextBenchmarks and Metrics

Last updated 1 year ago

Was this helpful?

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

✅

Recommended (see below)

✅

Potential information schema and backup compatibility issues.

✅

Potential information schema issues.

If you experience any issues using the supported SQL editors above, please so we can investigate and help.

Setting up Dolt with Tableplus

is the recommended SQL editor to use with Dolt. Let's clone a Dolt database and connect it to Tableplus. We have a that walks through this experience as well.

Step 1: Cloning a database.

Open your terminal and clone the following .

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

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

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

Step 2: Setting up your server

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

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

Step 3: Connecting our server with Tableplus

Click on create a new connection:

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

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.

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

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

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:

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

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 .

If you haven't already go ahead and install Tableplus from :

If you have any additional issues please file them .

file an issue on GitHub
Tableplus
video
database
here
here
here
Tableplus
Datagrip
MySQL Workbench