SELECT *

Engines POSTGRES

WHERE id = 'local'

INDEXED

MYSQL

INNER JOIN

GROUP BY

LOCALLY

Private Engine

100% Local Inference · Zero Data Egress

Local AI for SQL.
No Cloud, No Data Leaks.

The local AI copilot for SQL analysts. Generate complex queries from plain English using only your machine's hardware.

Get the Beta access

Be among the first to access Truncate

System Core Active

Efficiency Verified

3-Second Clarity

Truncate is a local AI SQL assistant that respects your data through native architecture.

01. Ask in English

"Show revenue by month"

02. Generates SQL

AI analyzes your local schema with 100% native inference.

03. Runs Locally

Entirely on your machine hardware. 0 bytes data egress.

Zero Data Leakage Verified Architecture Built for Privacy

Compliance Risk Detected

Data Egress Leak

Cloud LLMs are
a security risk for your data.

Data Leaks

Sending your database schema to hosted copilots violates your client’s NDA and compliance rules. Exposing table structures is a one-way door to security breaches.

AI-Hallucinations

Generic LLMs suggest orders_v2 when your database only has orders. One hallucinated deletion is all it takes to ruin production.

Vendor Lock-in

External AI tools force you to upload your data to their servers. Truncate keeps you in control, running locally on your own terms with open-source models.

Secure Local Bridge

Local Architecture

LOCAL-FIRST
BY ARCHITECTURE

Truncate provides a secure, local bridge between your natural language and your database, ensuring every query is verified, local, and private.

Zero Data Leaves

Pass security reviews faster and keep sensitive client data on-prem. AI inference runs 100% locally on your hardware.

Schema Locked

No more broken queries from hallucinated columns. The AI is strictly constrained to your actual database metadata.

Production Safe

Senior engineers can approve or reject destructive queries in one click. Every write operation requires manual confirmation .

Enterprise Comparison

Capability	TRUNCATE	Legacy AI	Manual SQL
Data Sovereignty Local execution control	100% Local Zero Egress	Cloud-Dependent	N/A
Schema Integrity Hallucination prevention	Metadata Locked Verified Schema	Hallucination Risk	Human Error
Safety Guardrails Production write protection	Human-in-Loop Hard Confirmation	None	Manual Review
Inference Speed Execution performance	Zero Latency Native Perf	Variable / Laggy	Extreme Overhead
Audit Readiness Compliance & logging	Full Audit SOC2 Ready	Cloud Blackbox	Manual Logs

Infrastructure Grade Standard

Advantage

Risk

Limitation

End-to-End Local Execution

Workflow

How It Works

Connect your local database, ask questions in plain English, and get verified results in seconds. No cloud. No data egress. 100% Native Inference.

01. Connect

Local Postgres, MySQL, or SQLite.

02. Ask

Natural language to validated SQL.

03. Review

Instant results, 100% private.

Setup Time

~1 Minute

OS Support

macOS (Beta)

Linux/Win (Roadmap)

DB Support

Postgres, MySQL, SQLite

AI Engine

Local LLM (Private)

Truncate IDE • local_inference.sql

Local LLM Running

Static Example (Beta)

-- Generated from: 'Show me churned users'

SELECT * FROM users

WHERE status = 'churned'

AND last_login > 30;

● AI Safe Query Generated

"Show me churned users in the last 30 days"

✓ Schema verified•100% local•Safe to run

CONNECTED TO LOCAL_PROD

UTF-8 • SQL • 12ms

Result Set • Local Execution

Explain

Export

AI Generated SQL (Verified Local)

SELECT * FROM users WHERE status = 'churned' AND last_login > 30;

User Email

Inactive

Tier

Reason

Running Local Inference...

Verified Live Data (3 rows)

Data Egress: 0 bytes. All processing local.

Native Connectivity

Engines built for speed & safety

Direct local connections. Zero data egress. AI that stays on your machine.

DONE

SQLite

Blazing fast native .sqlite support.

Direct file-system integration

No database server required

Instant query responsiveness

DONE

CSV

Turn flat files into queryable engines.

Query CSVs with pure SQL

No upload or import necessary

Supports files up to 2GB locally

DONE

PostgreSQL

Direct socket-level introspection for Postgres.

Works with local Docker & Unix sockets

Zero-config schema discovery

Handles 10k+ tables seamlessly

DONE

MySQL

High-performance bridge for local MySQL.

Optimized for local-dev latency

Full visibility into complex schemas

Secure-by-default local connections

Shipping

Microsoft SQL Server

Enterprise-grade SQL Server support.

Full T-SQL support

Connect to local or remote instances

SSMS-like experience

Shipping

MariaDB

The open source relational database.

Drop-in replacement for MySQL

High performance storage engines

Active community support

Planned

Oracle Database

Connect to the worlds most popular database.

PL/SQL support

Enterprise performance

Advanced security features

Planned

CockroachDB

Distributed SQL for global apps.

Postgres-wire compatible

Horizontal scalability

Resilient architecture

Planned

Amazon Aurora

MySQL and PostgreSQL compatible.

Cloud-native performance

Serverless scaling

High availability

Shipping

Google Cloud SQL

Fully managed relational database service.

MySQL, PostgreSQL, SQL Server

Easy integration with GKE/BigQuery

Automated backups

Shipping

Azure SQL Database

Managed, intelligent SQL in the cloud.

AI-powered performance

Hyperscale storage

Serverless compute

DONE