Connect to Databend
Databend supports multiple connection methods to suit different use cases. All SQL clients and drivers below work with both Databend Cloud and self-hosted Databend deployments - the only difference is how you obtain your connection string.
Obtaining Connection Strings
| Deployment | How to Get Connection String | Connection Format |
|---|---|---|
| Databend Cloud | 1. Log in to Databend Cloud 2. Click Connect on the Overview page 3. Select your database and warehouse 4. Copy the generated connection details | databend://<username>:<password>@<tenant>.gw.<region>.default.databend.com:443/<database>?warehouse=<warehouse_name> |
| Self-Hosted | Use your deployment information: • Default user: root (or custom SQL user)• Host: your server address (e.g., localhost) | databend://<username>:<password>@<hostname>:<port>/<database> |
SQL Clients & Tools
| Client | Type | Best For | Key Features |
|---|---|---|---|
| BendSQL | Command Line | Developers, Scripts | Native CLI, Rich formatting, Multiple install options |
| DBeaver | GUI Application | Data Analysis, Visual Queries | Built-in driver, Cross-platform, Query builder |
Developer Drivers
| Language | Driver | Use Case | Documentation |
|---|---|---|---|
| Go | Native Driver | Backend Applications | Golang Guide |
| Python | Python Connector | Data Science, Analytics | Python Guide |
| Node.js | JavaScript Driver | Web Applications | Node.js Guide |
| Java | JDBC Driver | Enterprise Applications | JDBC Guide |
| Rust | Native Driver | System Programming | Rust Guide |
Connection Methods
| Method | Security Level | Use Case | Setup Complexity |
|---|---|---|---|
| Direct Connection | Standard | Development, Testing | ⭐ Simple |
| AWS PrivateLink | High | Production, Enterprise | ⭐⭐⭐ Advanced |