NTXM Logo

SQL Studio For Modern Database Workflows

Manage PostgreSQL, MySQL, and SQLite from a fast desktop workspace built for developers.

Download FreeView Release

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 modern desktop workspace for PostgreSQL, MySQL, and SQLite. Execute queries, explore schemas, manage data, and inspect database objects through a unified interface designed for speed, clarity, and developer productivity.

3

Database engines supported out of the box.

10+

Database object types including tables, views, functions, procedures, and triggers.

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.

Smarted Finance

Simple Steps to Smarter Finance

Automate your financial operations, track performance in real time, and make confident decisions backed by clear insights.

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

Manage connections, schemas, data, functions, procedures, and SQL files from a single interface.

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
42
Triggers
36
Indexes
18
Relations
Data Visibility

Take Control of Your
Database Ecosystem

An all-in-one platform to explore, query, and optimize your database architectures natively on your desktop.

3
Database Engines
12+
Database Objects
Native
Desktop App
View All Releases

Frequently Asked
Questions

Got a question? Here's everything you need to know before getting started.

SQL Studio is a desktop database workspace for PostgreSQL, MySQL, and SQLite with schema visualization, query execution, data editing, and database inspection tools.

Yes. SQL Studio can be downloaded and used without a subscription.

PostgreSQL, MySQL, and SQLite are currently supported, with additional engines planned in future releases.

Yes. SQL Studio can open .db, .sqlite, and .sqlite3 files directly from your machine.

Yes. Data can be exported directly from result tables and database views.