Download TiDB JDBC Driver

Download the TiDB JDBC driver, copy the JDBC URL into DbSchema, and start designing schemas with ER diagrams — free Community Edition.

Connect TiDB in DbSchema Install the driver, open a connection, reverse engineer your schema, and sync changes visually.

TiDB guide Free Download

About the TiDB JDBC driver

A JDBC driver is a Java .jar library that lets applications connect to TiDB. DbSchema uses JDBC to reverse engineer schemas, run SQL, and generate documentation. Driver files are usually published by the database vendor or an open-source project.

JDBC URL format

Host, port, database name, and SSL options are passed in a URL starting with jdbc:. Each TiDB driver uses its own syntax — see the connection details below.

The TiDB JDBC driver

TiDB is a distributed SQL database developed by PingCAP that combines OLTP and OLAP capabilities in a single platform, known as HTAP. It is MySQL-compatible, allowing existing MySQL applications to migrate with minimal changes, while providing horizontal scalability and high availability through its distributed architecture. TiDB separates storage (TiKV and TiFlash) from compute, enabling independent scaling of each tier.

The TiDB JDBC URL

Required File(s): mysql-connector-j-xxx.jar
Java Driver Class: com.mysql.cj.jdbc.Driver
JDBC URL: jdbc:mysql://{HOST}:{PORT}/{DB}
Website: TiDB by PingCAP

TiDB listens on port 4000 by default (not MySQL's standard 3306). Use the MySQL Connector/J driver. For TiDB Cloud, connection strings are available from the TiDB Cloud console and require SSL: append ?sslMode=VERIFY_IDENTITY&serverSslCert=/path/to/cert.

DbSchema and TiDB

DbSchema connects to TiDB using the MySQL JDBC driver, visualizing TiDB's distributed SQL schemas, enabling MySQL-compatible query authoring, and supporting schema design for both OLTP and HTAP workloads across TiKV and TiFlash storage engines.