Query your data in

NexusData is a local-first, agentic SQL pipeline. No cloud uploads, no SaaS subscriptions, and zero data leakage. Talk to any database natively on your hardware.

Deploy locally
git clone nexusdata-core.git

Pipeline Mechanics

Every query undergoes a rigid anatomical breakdown before execution. We don't just "guess" SQL—we construct it through verified reasoning stages.

01

Input Normalizer

Sanitizes PII, standardizes casing, and removes colloquial noise using local regex + AST guards.

02

Goal Identifier

Deconstructs the prompt into a structured JSON "Intent Object" identifying metrics and filters.

03

Reference Resolver

Maps fuzzy terms (e.g., "sales") to actual DB schema (e.g., fact_orders.total_price) using LanceDB vector cache.

04

Query Planner

Determines Join paths and selects the correct SQL dialect (Postgres, Oracle, DuckDB) via SQLAlchemy 2.x.

05

Executor & Healer

Executes SQL. If a traceback occurs, the Self-Healer feeds the error back to the Planner for automatic correction.

// System.Pipeline initializing...

Connectivity Matrix

Standard SQL

  • PostgreSQL psycopg2-binary
  • MySQL/MariaDB pymysql
  • SQLite built-in

Enterprise & Cloud

  • MS SQL Server pyodbc
  • Oracle cx_Oracle
  • Snowflake snowflake-sqlalchemy

Analytics Engines

  • DuckDB included
  • BigQuery sqlalchemy-bigquery
  • CockroachDB sqlalchemy-cockroachdb

LLM Configuration

Your API key is only stored in .env. It never touches our servers.

Google Gemini

Fastest setup, generous free tier.

AI Studio →
OpenAI

Gold standard for complex reasoning.

Platform →
Anthropic

Best for long context & accuracy.

Console →
OpenRouter

Universal bridge for open models.

Dashboard →

Installation

1
Clone & Environment
git clone https://github.com/AshwiniShankwaar/NexusData.git
python -m venv .venv
source .venv/bin/activate
2
Dependencies
pip install -r requirements.txt
3
CLI Wizard
python nexus_cli.py
Prerequisites
  • - Python 3.11+
  • - 8GB RAM minimum
  • - Valid LLM API Key
Security

Your .env file is git-ignored. All database credentials remain on your disk.