Connectivity
Eight databases. Native drivers. Zero bloat.
Datara Studio connects to MySQL, PostgreSQL, SQLite, MSSQL, Oracle, MariaDB, Redis, and MongoDB using native Go drivers — no ODBC, no Java, no Docker required.
Supported databases
MySQL
Full MySQL 5.7 and 8.x support. Stored procedures, views, triggers, events, and user management.
PostgreSQL
Complete PostgreSQL support including JSONB, arrays, custom types, extensions, and materialized views.
SQLite
Open any local .db or .sqlite file instantly. Full SQLite feature support including FTS5 and JSON1.
MSSQL
SQL Server support with T-SQL syntax, stored procedures, and cross-database queries.
Oracle
Oracle Database support with PL/SQL, packages, sequences, and tablespace management.
MariaDB
Full MariaDB compatibility including Aria engine, sequences, and system-versioned tables.
Redis
Key browser, value inspector, command runner, pub/sub monitoring, and TTL management.
MongoDB
Collection browser, document editor, aggregation pipeline builder, and index management.
Security
Secure connections by default
Every connection supports SSH tunnelling and SSL/TLS encryption. Credentials are stored in your operating system's native keychain — never in plain text, never transmitted anywhere.
- SSH tunnel support for all database types
- SSL/TLS with custom certificates
- OS keychain credential storage (macOS Keychain, Windows Credential Manager, Linux Secret Service)
- Connection testing before save
- No telemetry — credentials never leave your machine
Connection management
Connection Groups
Organise connections into groups — by project, environment, or team. Colour-code for quick visual identification.
Quick Switch
Switch between connections with a keyboard shortcut or the connection palette. Your query tabs remember their connection context.
Environment Tags
Tag connections as Production, Staging, or Development. Visual indicators prevent accidental operations on the wrong environment.