Relational Databases
PostgreSQL
Powerful open-source relational database with advanced features
MySQL
Popular open-source relational database
MariaDB
MySQL-compatible database with enhanced features
SQL Server
Microsoft’s enterprise relational database system
Embedded Databases
SQLite
Lightweight file-based SQL database
DuckDB
Analytical SQL database for OLAP workloads
Analytics & OLAP
ClickHouse
Column-oriented database for real-time analytics
NoSQL Databases
MongoDB
Document-oriented NoSQL database
Redis
In-memory key-value data store
Database Drivers & Versions
Zequel uses the following official database drivers:| Database | Driver | Version |
|---|---|---|
| PostgreSQL | pg | ^8.13.1 |
| MySQL | mysql2 | ^3.11.5 |
| MariaDB | mysql2 | ^3.11.5 |
| SQL Server | mssql | ^12.2.0 |
| SQLite | better-sqlite3 | ^11.6.0 |
| DuckDB | @duckdb/node-api | ^1.4.4-r.1 |
| ClickHouse | @clickhouse/client | ^1.16.0 |
| MongoDB | mongodb | ^7.0.0 |
| Redis | ioredis | ^5.9.2 |
Common Features
All supported databases provide:- Connection Management: Secure connections with SSL/TLS support
- Query Execution: Interactive query editor with syntax highlighting
- Schema Browser: Navigate databases, tables, views, and relationships
- Data Viewing: Browse and filter table data with pagination
- Export/Import: Backup and restore capabilities
Database-Specific Features
Each database driver implements features specific to that system:SQL Databases (PostgreSQL, MySQL, MariaDB, SQL Server)
- Tables, views, and materialized views
- Indexes and foreign key constraints
- Stored procedures and functions
- Triggers and sequences
- User and role management
Embedded Databases (SQLite, DuckDB)
- File-based operation
- Direct file access
- Local schema editing
Analytics (ClickHouse)
- MergeTree engine support
- Data skipping indexes
- Partitions and materialized views
- Column-oriented storage
NoSQL (MongoDB, Redis)
- Document/key-value operations
- Schema-less data modeling
- Native query languages
- Collections and key management
Not all features are available for every database type. Check individual database pages for specific capabilities and limitations.