DB Loadr

Multi-database studio for querying, exploring, and managing your data sources — 22+ connectors included.

Overview

DB Loadr is a full-featured database client that runs inside your Calliope workspace. Connect to virtually any database, run queries, browse schemas, and move data between sources — all from your browser. With 22+ built-in connectors, concurrent query execution, and GitHub-authenticated git workflows, it’s the fastest way to get hands-on with your data.

Key Features

• 22+ Database Connectors — PostgreSQL, MySQL, MongoDB, ClickHouse, Redis, SQLite, DuckDB, and many more
• Query Editor — SQL editor with syntax highlighting, autocomplete, and a Write mode toggle to enable data-modifying queries (INSERT/UPDATE/DELETE)
• Schema Explorer — Browse tables, columns, indexes, and relationships visually
• Concurrent Query Execution — Run multiple queries simultaneously with background task support
• Unified Connections Sidebar — Sources, targets, and servers consolidated in a single panel
• Credential Management — Securely store and reuse connection credentials across sessions
• GitHub OAuth — Authenticate to GitHub via device flow, configurable directly from the Settings UI (client ID pre-configured)
• Performance Tab — Monitor query execution performance with per-panel opt-in controls
• Shared Templates — Organization-wide query templates for common operations
• AI-Assisted Queries — Generate and explain SQL with AI assistance (bring your own API key)

Getting Started

1. From the Hub, click DB Loadr to launch
2. The database studio opens with the connections sidebar
3. Click New Connection to connect your first database
4. Select your database type and enter connection details
5. Start running queries

Connecting a Database

DB Loadr supports connections to:

SQL Databases

• PostgreSQL, MySQL, MariaDB, SQLite
• Microsoft SQL Server, Oracle

Analytical / Columnar

• ClickHouse, DuckDB, BigQuery, Snowflake, Redshift

NoSQL & Other

• MongoDB, Redis, Elasticsearch
• REST APIs, CSV/JSON files

Connection credentials are stored securely and persist across sessions. The Unified Connections Sidebar groups all your sources, targets, and servers in one place for easy switching.

Query Editor

The query editor supports:

• SQL syntax highlighting for all supported dialects
• Multi-tab query workspace
• Query history
• Result export (CSV, JSON)
• Row-level filtering and sorting in results
• Write mode — toggle to enable data-modifying queries; off by default to prevent accidental changes

Concurrent Query Execution

Run multiple queries in parallel without waiting for each to complete. Long-running queries execute in the background — results appear when ready, and you can continue working in other tabs.

Performance Monitoring

The Performance tab shows execution metrics for your queries. Enable per-panel performance tracking in the query editor to capture timing data for optimization.

GitHub OAuth

DB Loadr integrates GitHub authentication for git-backed data workflows:

1. Go to Settings → GitHub
2. Click Connect GitHub to start the device flow
3. Authorize in your browser
4. Your GitHub credentials are stored for repo access in query workflows

Shared Templates

Your organization can publish query templates to a shared library. These appear in DB Loadr for all users and provide a quick starting point for common data operations — reporting queries, data quality checks, ETL scripts, and more.

Sample Databases

Calliope includes sample MySQL and PostgreSQL databases preconfigured in DB Loadr:

• Sample MySQL — For testing SQL queries and exploring a demo dataset
• Sample PostgreSQL — Same for PostgreSQL workflows

These are available without any connection setup.

When to Use DB Loadr