# 2TI Native DB Studio - Official LLM & Agent Index

> Query, model, and optimize at native C/Rust speed - with your own local SQL Copilot. - Ultra-fast, multi-tab native Rust/Tauri GUI for PostgreSQL, MySQL, SQLite, and Redis. Uses the shared local Ollama daemon to translate natural language into schema-aware SQL and explain slow EXPLAIN ANALYZE plans without cloud telemetry.

- Canonical App Page: https://2tinteractive.com/apps/db-studio
- Knowledge Base Index: https://2tinteractive.com/apps/db-studio/kb
- Global Ecosystem Index: https://2tinteractive.com/apps/llms.txt
- Lifecycle Stage: Beta
- Target Platforms: Zorin OS · Debian · Ubuntu · macOS
- Current Build / Version: 0.2.0
- Primary Linux Package (.deb): https://2tinteractive.com/apps/releases/2ti-db-studio_0.2.0_amd64.deb
- Licensing Model: Low-Fee Commercial Suite Ready · 30-Day Evaluation on Release

## Local LLM & Zero-Cloud AI Architecture (Ollama)

### Schema-Aware SQL Translation & Plan Optimization on your own GPU.

Feed your schema catalog into your local Ollama daemon (qwen2.5-coder or gemma4e4b). Ask complex analytical questions, generate migration scripts, and diagnose slow queries without sending your database structure or sensitive records to third-party cloud LLMs.

- Ollama Local Runtime
- qwen2.5-coder
- gemma4e4b
- PostgreSQL
- MySQL
- SQLite
- Redis
- Zero Cloud Telemetry

## Core Capabilities

- **Instant Native Cold-Start (<12ms).**: DBeaver forces an 800 MB Java JVM runtime; Beekeeper and Azure Data Studio drag multi-tab Electron bloat. 2TI Native DB Studio boots instantly in Rust with under 25 MB RAM.
- **Schema-Aware Local Ollama Text-to-SQL.**: Type natural language prompts ('Show me all active subscriptions expiring this month with pending invoices'). Local Ollama reads your table DDL and generates optimized, parameterized queries.
- **Visual EXPLAIN ANALYZE & Index Advisor.**: Diagnose slow queries visually. Highlights sequential scans, missing indexes, and costly nested loops, providing one-click index recommendations without uploading plans to cloud optimizers.

## Knowledge Base Articles (Raw Markdown Endpoints)


## Frequently Asked Questions

- **How does 2TI Native DB Studio compare to TablePlus or Navicat?** - TablePlus and Navicat are proprietary Mac/Windows benchmarks that treat Linux as a second-class afterthought or abandon it altogether. DB Studio delivers that same razor-sharp, native multi-tab speed in Rust and Tauri, enhanced with local Ollama SQL translation.
- **Does the SQL AI Copilot send my database schema or records to the cloud?** - Never. The SQL translation and query analysis execute exclusively on your local GPU via your local Ollama daemon on localhost:11434. No schema DDL, credentials, or table records ever leave your machine.
- **Which database engines are supported?** - PostgreSQL, MySQL, SQLite, Redis, and MariaDB are supported in the core engine, with SSH tunneling, SSL certificate authentication, and read-only connection locks built-in.
- **When will early preview builds be available for ZorinOS and macOS?** - We are currently in active development. Enter your email in the waitlist below to receive development milestones and first access to the 30-day pre-release binary.