storingUnicorns 🦄

A terminal-based database client inspired by JetBrains DataGrip, built with Rust and ratatui.

Features

• Multi-database support (PostgreSQL, MySQL, SQLite, SQL Server)
• Connection management with dialog-based creation
• Schema browser (tables list)
• SQL query editor
• Results table with navigation
• Persistent configuration
• Contextual help bar

Project Structure

src/
├── main.rs          # Entry point, event loop, keybindings
├── config/          # Configuration management
│   └── mod.rs       # AppConfig: load/save connections
├── db/              # Database layer
│   ├── mod.rs
│   └── connector.rs # DatabaseConnection: unified DB interface
├── models/          # Data structures
│   ├── mod.rs
│   └── connection.rs # ConnectionConfig, QueryResult, Column
├── services/        # Application logic
│   ├── mod.rs
│   └── app_state.rs # AppState: runtime state, dialogs
└── ui/              # Terminal UI
    ├── mod.rs
    ├── layout.rs    # Main layout, panel arrangement
    └── widgets.rs   # Panel renderers, dialogs, help bar

Keybindings

Main Interface

New Connection Dialog

Configuration

Connections are stored in ~/.config/storingUnicorns/config.toml:

[[connections]]
name = "Local Postgres"
db_type = "Postgres"
host = "localhost"
port = 5432
username = "postgres"
password = "secret"
database = "mydb"

[[connections]]
name = "SQLite DB"
db_type = "SQLite"
database = "./data.db"

Building

cargo build --release

Running

cargo run
# or after building:
./target/release/storingUnicorns

Layout

┌─────────────┬─────────────────────────────────┐
│ Connections │  Query Editor                   │
├─────────────┤                                 │
│ Tables      ├─────────────────────────────────┤
│             │  Results                        │
└─────────────┴─────────────────────────────────┘
│ Status: Connected to mydb                     │
├───────────────────────────────────────────────┤
│ Enter Connect │ n New │ d Delete │ Tab Next  │
└───────────────────────────────────────────────┘

TODO

• Multi-line query editor with proper cursor movement
• Table structure view (columns, types, indexes)
• Query history
• Result set export (CSV, JSON)
• Syntax highlighting for SQL
• Async query execution with cancellation
• Tab completion for table/column names
• Edit existing connections