Database Support
Database Support
Supported databases and their features
Database Support
data-peek supports PostgreSQL, MySQL, Microsoft SQL Server, SQLite, and ClickHouse (beta) databases.
Supported Databases
| Database | Status | Features |
|---|---|---|
| PostgreSQL | ✓ Full Support | All features |
| MySQL | ✓ Full Support | All features |
| Microsoft SQL Server | ✓ Full Support | All features |
| SQLite | ✓ Supported | Local file databases |
| ClickHouse | ✓ Beta | Query and browse |
PostgreSQL
Full-featured PostgreSQL support
MySQL
MySQL database support
SQL Server
Microsoft SQL Server support
SQLite
Local SQLite file databases
ClickHouse
Query and browse ClickHouse over HTTP (beta)
Feature Comparison
| Feature | PostgreSQL | MySQL | SQL Server | SQLite | ClickHouse |
|---|---|---|---|---|---|
| Query execution | ✓ | ✓ | ✓ | ✓ | ✓ |
| Multiple result sets | ✓ | ✓ | ✓ | ✓ | ✓ |
| Schema explorer | ✓ | ✓ | ✓ | ✓ | ✓ |
| Table preview | ✓ | ✓ | ✓ | ✓ | ✓ |
| Inline editing | ✓ | ✓ | ✓ | ✓ | - |
| Table designer | ✓ | ✓ | ✓ | ✓ | - |
| ER diagrams | ✓ | ✓ | ✓ | ✓ | ✓ |
| Query execution plans | ✓ | ✓ | ✓ | ✓ | ✓ |
| EXPLAIN ANALYZE | ✓ | - | - | - | - |
| Views browser | ✓ | ✓ | ✓ | ✓ | ✓ |
| Stored procedures | ✓ | ✓ | ✓ | - | - |
| Functions | ✓ | ✓ | ✓ | - | - |
| Sequences | ✓ | - | ✓ | - | - |
| Custom types (enums) | ✓ | ✓ | - | - | ✓ |
| JSON support | ✓ | ✓ | ✓ | ✓ | - |
| Array types | ✓ | - | - | - | - |
| SSH tunnels | ✓ | ✓ | ✓ | - | ✓ |
ClickHouse support covers querying and browsing. See ClickHouse for the features that are hidden on ClickHouse connections.
Connection Security
All remote databases support:
- SSL/TLS connections
- Password authentication
- Encrypted credential storage (using OS keychain)
- SSH tunnel connections
SQLite uses local file access and doesn’t require network connections.