NTXM Logo
v0.1.3 · Database Objects

SQL Studio For Modern Database Workflows

Local-first desktop IDE for PostgreSQL, MySQL, and SQLite — schema canvas, data browser, and Database Objects with virtual SQL + Ask Agent.

Unsigned Binary NoticeAs a solo developer, my installers are currently unsigned. Windows Defender, SmartScreen, or your browser may show a "Windows protected your PC" warning or falsely flag the file as harmful. To proceed, click "More info" → "Run anyway". Use at your own risk.

PostgreSQL • MySQL • SQLite

PostgreSQL
MySQL
SQLite
Untitled Database
users
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
//// -- LEVEL 1
//// -- Tables and References

// Creating tables
Table users as U { id int [pk, increment] // auto-incro.
full_name varchar
created_at timestamp
country_code int
}

Table countries { code int [pk]
name varchar
continent_name varchar
}
// Creating references
// You can also define relationship se...

//// -- Adding column settings
Table order_items { order_id int [ref: > orders.id]
product_id int
quantity int [default: 1]
}

Ref: order_items.product_id > products.id
/ users
id
int
full_name
varchar
created_at
timestamp
country_code
int
/ orders
id
int
user_id
int
status
varchar
created_at
timestamp
/ products
id
int
name
varchar
merchant_id
int
price
int
status
varchar
/ countries
code
int
name
varchar
continent_name
varchar
What is It ?

SQL Studio is a local-first desktop IDE for PostgreSQL, MySQL, and SQLite. Connect securely, run queries in Monaco, explore schemas on a canvas, browse data, and inspect Database Objects — including virtual SQL with Ask Agent Keep / Revert.

3

Database engines supported out of the box.

4+

Object browsers for tables, views, functions, and procedures — with virtual SQL tabs and Keep / Revert.

Best

Online / Offline desktop experience with direct database connectivity.

SQL Studio

Everything You need to Manage Your Database

Query data, inspect schemas, manage relations, and explore structures from a single,unified workspace. Connect instantly to PostgreSQL, MySQL, or SQLite and maintain modern databases.

SQL Studio
Visual Mapping

Visual Schema Exploration

Understand table relationships instantly with an interactive schema view built for real-world databases.

postgres
100%
/categories
2 columns • 0 rows
id
PKNN
integer
name
NN
character varying
/products
5 columns • 0 rows
id
PKNN
integer
category_id
FK
integer
name
NN
character varying
description
text
price
numeric
/users
4 columns • 0 rows
id
PKNN
integer
username
NN
character varying
email
NN
character varying
created_at
timestamp without time zone
/posts
6 columns • 0 rows
id
PKNN
integer
user_id
FK
integer
title
character varying
content
text
published
boolean
created_at
timestamp without time zone
/comments
5 columns • 0 rows
id
PKNN
integer
post_id
FK
integer
user_id
FK
integer
content
text
created_at
timestamp without time zone
Scroll to zoom · V/H/B tools · F to fit
main
PostgreSQL
Exec: 264ms0 rowsUTF-8SQL
0 warnings
postgres
update_timestamp_trigger
EXPLORER
postgres
TABLES (12)
VIEWS (4)
PROCEDURES (3)
FUNCTIONS (5)
sql
add_data_in_tables.sql
create_tables.sql
drop_tables.sql
first.sql
read.sql
create_tables.sql
add_data_in_tables.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
-- =========================================================================
-- COMPLETE POSTGRESQL TEST SCHEMA
-- Tables + Indexes + Views + Materialized Views
-- Functions + Procedures + Triggers
-- =========================================================================
-- =========================================================================
-- TABLES
-- =========================================================================
CREATE TABLE users (
id SERIAL PRIMARY KEY,
username VARCHAR(50) UNIQUE NOT NULL,
email VARCHAR(255) UNIQUE NOT NULL,
full_name VARCHAR(255),
is_active BOOLEAN DEFAULT TRUE,
created_at TIMESTAMP DEFAULT NOW()
);
CREATE TABLE profiles (
user_id INTEGER PRIMARY KEY REFERENCES users(id) ON DELETE CASCADE,
bio TEXT,
website VARCHAR(255),
avatar_url TEXT
);
CREATE TABLE categories (
id SERIAL PRIMARY KEY,
name VARCHAR(100) UNIQUE NOT NULL
);
INSPECTOR
GENERAL
Name
update_timestamp_trigger
Type
FUNCTION
DEFINITION
BEGIN
NEW.updated_at := NOW();
RETURN NEW;
END;
main
PostgreSQL
Item: update_timestamp_trigger
Exec: 264ms0 rowsUTF-8SQL
0 warnings
SQL Studio
Workspace

Built For Daily SQL Work

Run queries, inspect structures, edit records, export data, and manage database objects without switching tools.

New in v0.1.3

The workspace, as it ships

Explorer, Monaco editor, results grid, and Agent BETA — the same chrome you get in the official v0.1.3 installer.Database Objects, virtual SQL, and Ask Agent Keep / Revert live inside this shell.

Release notes
SQL Studio — PostgreSQL · postgres
Connected
Explorer
public
fun_join.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
customer_namecustomer_emailtotal_orderslifetime_spendavg_order_valuelast_order_at
Nit...nit...926036.002892.892026-09-01
Pri...pri...614820.502470.082026-08-28
Aar...aar...46120.251530.062026-08-19
Meh...meh...00.00NULLNULL
Kab...kab...00.00NULLNULL
5 rows returnedExecution time: 78ms
AgentBETA
2.3%
Editor action
//?/C:/Users/nitiksh/Documents/sql files/fun_join.sql

Ran successfully! ✅ 5 rows returned in 78 ms. The masking works perfectly — names and emails show only the first 3 characters plus ...

customer_nameordersspend
Nit...926036
Pri...614820
Meh...00

Your top customer is a 💎 Diamond with 9 orders and ₹26,036 lifetime spend. Two active users haven't ordered yet (😟). Results are in the Query Results panel.

Enter to send · Shift+Enter for newline · @ to attach files

PostgreSQL · aws-1-ap-southeast-1.pooler.supabase.com / publicItem: orders
Exec: 78ms5 rowsUTF-8SQLv0.1.3

Explorer + Objects

Tables, views, procedures, and functions in the sidebar — Database Objects panel keeps the same selection in sync.

Editor · Run · Results

Monaco SQL with a green Run control, masked result cells, and a status line that mirrors the live app.

Agent BETA

DeepSeek Flash with Thinking on — tool cards, mini result previews, and Keep / Revert for virtual:// object SQL.

Core Workspace

Inspect, script, and export

Table designer, SQL file explorer, and CSV/JSON export — the everyday tools you reach for after you connect.

products

Columns
Indexes
id
integerPK
category_id
integerFKnull
name
character varying
description
textnull
price
decimal
stock
integernull
metadata
jsonbnull
created_at
timestamp without time zonenull
sql
FILES (8)
001_init_schema.sql
002_seed_admin_users.sql
migrate_legacy_data.sql
monthly_revenue_report.sql
cleanup_orphaned_records.sql
optimize_search_indexes.sql
rollback_schema_v2.sql

Export Data

Format

Rows to Export

Workspace Overview

Built For
Developers And
Database Teams

Unified Database Workspace

Connections, schemas, data grids, SQL files, and Database Objects — including virtual:// definitions for views and routines.

Visual Schema Exploration

PostgreSQL, MySQL & SQLite

Download Now
publicTABLE
users
24 Columns
publicTABLE
products
12 Columns
publicPROCEDURE
restock_product
Executable
publicFUNCTION
get_user_count
Returns Int

Database Objects

Total Objects

12 Objects
24
Tables
12
Views
18
Functions
28
Procedures
36
Indexes
—
Triggers
Data Visibility

Take Control of Your
Database Ecosystem

Tables, views, functions, and procedures in one panel — synced with Explorer, openable as virtual SQL, with Ask Agent Keep / Revert when you need a second pair of eyes.

3
Database Engines
12+
Database Objects
Native
Desktop App
View Release Notes

Frequently Asked
Questions

Everything you need to know about SQL Studio v0.1.3 before you download.

SQL Studio is a local-first desktop database IDE for PostgreSQL, MySQL (MariaDB-compatible), and SQLite. It includes Connection Hub, Monaco SQL editor, schema canvas, data browser, Database Objects (tables, views, functions, procedures), and an optional DeepSeek agent.

Yes. You may install and use the official application free of charge for personal or commercial work. The product is proprietary (not open source). You may redistribute only the unmodified official installer with SQL Studio / NTXM branding intact.

Engines: PostgreSQL, MySQL/MariaDB-compatible, and SQLite. Platforms: Windows, macOS, and Linux. No other engines ship in the current release.

Browse tables, views, functions, and procedures in one panel. Open definitions as virtual:// SQL tabs, edit with Ask Agent, then Keep or Revert. Explorer selection stays in sync. Triggers remain coming soon.

Credentials are encrypted at rest with AES-256-GCM in the app’s local store — not uploaded by the app core. There is no product telemetry. Optional DeepSeek agent calls leave the machine only when you enable an API key and use the agent.

Yes — optional jump host with password or private key, and TOFU known-hosts after the first successful handshake.

Data export supports CSV and JSON from result tables and views. Schema canvas exports PNG and SVG. SQL dump export is not included in this release.

DeepSeek only (deepseek-v4-flash, deepseek-v4-pro). Other assistant providers are not shipped.