SQL connectors, libraries, drivers, APIs, and tools

Databricks has SQL connectors, libraries, drivers, APIs, and tools that allow you to connect to Databricks, interact programmatically, and integrate Databricks SQL functionality into applications written in popular languages such as Python, Go, JavaScript and TypeScript.

For recommendations for when to use connectors or drivers, see Which developer tool should I use?.

Name	Allows you to
SQL connnector to Python	Run SQL commands directly from Python code. This connector is easier to set up than other Python libraries, such as pyODBC.
SQLAlchemy	Use Python to interact with Databricks as a SQL data source. SQLAlchemy is a Python SQL toolkit that allows you to work with Python objects instead of writing raw SQL queries.
Python and pyODBC	Authenticate and establish a connection from your local Python code to Databricks using ODBC.
Databricks SQL Driver for Go	Integrate Go applications with Databricks and use familiar SQL interfaces in the Go programming environment.
Databricks SQL Driver for Node.js	Use JavaScript or TypeScript when building applications to query and manipulate data stored in Databricks.
Databricks ODBC Driver	Connect participating apps, tools, clients, SDKs, and APIs to Databricks through Open Database Connectivity (ODBC), an industry-standard specification for accessing database management systems.
Databricks JDBC drivers (Databricks OSS driver and Simba driver)	Connect participating apps, tools, clients, SDKs, and APIs to Databricks through Java Database Connectivity (JDBC), an industry-standard specification for accessing database management systems. Databricks JDBC Driver (OSS) is the latest version of the driver developed by Databricks. Databricks JDBC Driver (Simba) is an older version of the driver, which is developed by insightsoftware.
Databricks SQL Statement Execution API	Run SQL statements to access Databricks data and retrieve results without the need to install database drivers or manage persistent connections.
Databricks SQL CLI	Run SQL commands and scripts from the command line. The Databricks SQL CLI connects to Databricks and allows for integration into scripts and automation processes.
Databricks Driver for SQLTools for Visual Studio Code	Run SQL queries directly against Databricks from within Visual Studio Code.
DataGrip integration with Databricks	Use DataGrip's integrated development environment (IDE) to connect to Databricks for application development, providing a query console, schema navigation, plan explanation, smart code completion, real-time analysis and quick fixes, refactorings, version control integration, and other features.
DBeaver integration with Databricks	Integrate DBeaver, a multi-platform database tool that uses the JDBC protocol, to view and manage data in Databricks. Use the DBeaver SQL editor, data and schema migration tools, and database connection monitoring capabilities.
Connect to SQL Workbench/J	Use SQL Workbench/J, a Java-based tool, for connecting to data in Databricks and running SQL scripts without being constrained by operating system limitations.