Download InfluxDB JDBC Driver

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

About the InfluxDB JDBC driver

A JDBC driver is a Java .jar library that lets applications connect to InfluxDB. 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 InfluxDB driver uses its own syntax — see the connection details below.

The InfluxDB JDBC driver

InfluxDB is a purpose-built time-series database by InfluxData, designed for high-write-throughput metrics, monitoring, IoT sensor data, and DevOps observability. It provides a custom query language (InfluxQL, Flux) and native integrations with Grafana, Telegraf, and Kapacitor.

The InfluxDB JDBC URL

• Required File(s): influxjdbcXX.jar
• Java Driver Class: com.wisecoders.dbschema.influxdb.JdbcDriver
• JDBC URL: https://HOST:PORT/DB?org=PARAM&token=PARAM2
• Website: InfluxData

Download InfluxDB JDBC Driver

The driver archive is a zip file. Extract it and load the .jar files using DbSchema's Driver Manager.

For accessing the driver source code please visit the GitHub repository:

Driver Source Code

Connecting to InfluxDB

InfluxDB does not authenticate with a user and a password the way the other databases here do. What it wants is an organization and an API token, and both go into the URL.

1. Create an API token. In the InfluxDB UI, under the data or load-data section, generate a token and give it read access to the buckets you want to see. Copy it when it is shown — a token cannot be read back afterwards, only replaced.
2. Take the organization name. The URL carries ?org=. It is the organization the buckets belong to, not the bucket name, and getting the two the wrong way round returns an empty schema rather than an error.
3. Pick the matching Connection Mode. There are four entries: HTTP or HTTPS, each with a token or with a user and password. Choose HTTPS wherever the server has TLS, since the token travels in the URL. The optional days parameter limits how far back DbSchema reads when it infers the schema, which keeps the first connection quick on a large database.
4. Open port 8086 in the server's firewall. The database listens on port 8086 unless it was installed with a different one. A host firewall on the server blocks incoming connections on that port until a rule allows them. The firewall guide has the commands for Windows, ufw, firewalld and iptables.
5. Connect from DbSchema. In the Connection Dialog choose Remote computer or custom port, fill in the server host and the port, then press Test Connection to check that the server answers before you connect.

On InfluxDB Cloud the host comes from the console and TLS is compulsory; the organization and token work exactly as above.

DbSchema and InfluxDB

DbSchema connects to InfluxDB using the JDBC driver and renders measurements and tag keys as queryable schema objects. Use the SQL Editor to write InfluxQL queries and explore time-bucketed data in the result viewer.