Now in beta — free forever for individuals

One GUI for
every database

NoctuaDB Studio gives you a beautiful, fast interface to query, explore, and manage MySQL, PostgreSQL, SQLite, MongoDB, and Redis — all in one place.

Download Now View on GitHub

NoctuaDB Studio — localhost:5432 / production

Query

Table

Schema

SELECT u.id, u.name, u.email,
COUNT(o.id) AS total_orders
FROM users u
LEFT JOIN orders o ON o.user_id = u.id
WHERE u.created_at > '2024-01-01'
GROUP BY u.id
ORDER BY total_orders DESC
LIMIT 50;

ID	Name	Email	Orders	Status
#1042	Alice Martins	alice@example.com	87	Active
#983	Bruno Costa	bruno@example.com	64	Active
#777	Carla Silva	carla@example.com	41	Trial
#512	Daniel Rocha	daniel@example.com	19	New

Features

Everything you need,
nothing you don't

Built for developers who want power without the bloat.

✏️

Query Editor

Syntax highlight, autocomplete, multi-tab

🗂️

Schema Browser

Explore tables, columns, indexes, relations

📊

Data Grid

View, filter, sort, and edit rows inline

🔗

Connection Manager

Organize all your database connections

📤

Import & Export

CSV, JSON, SQL dump — one click away

Smart Query Editor

Write queries faster with syntax highlighting, intelligent autocomplete, and multi-tab support. Run queries against any engine with the same familiar interface.

-- Find top customers by revenue
SELECT
  c.id,
  c.name,
  SUM(o.total) AS revenue,
  COUNT(*) AS orders
FROM customers c
JOIN orders o ON o.customer_id = c.id
WHERE o.status = 'completed'
  AND o.created_at >= NOW() - INTERVAL '30 days'
GROUP BY c.id
HAVING revenue > 1000
ORDER BY revenue DESC;

CREATE TABLE analytics_events (
  id BIGSERIAL PRIMARY KEY,
  user_id INT REFERENCES users(id),
  event_type VARCHAR(80) NOT NULL,
  payload JSONB,
  created_at TIMESTAMPTZ DEFAULT NOW()
);

                    ✓ Query executed in 14ms · 0 rows affected
                  

Schema Browser

Visualize your entire database structure at a glance. Inspect columns, types, constraints, and foreign key relationships without writing a single query.

📋 users

idbigintPK

emailvarchar(255)

namevarchar(120)

created_attimestamptz

role_idintFK

📋 orders

idbigintPK

user_idbigintFK

totaldecimal(10,2)

statusvarchar(20)

Powerful Data Grid

Browse and edit table data with column sorting, filtering, and inline cell editing. Handles millions of rows without breaking a sweat.

ID ↕NameEmailOrders ↓

#1042Alice Martinsalice@example.com87

#983Bruno Costabruno@example.com64

#777Carla Silvacarla@example.com41

#512Daniel Rochadaniel@example.com19

#401Eva Souzaeva@example.com8

Showing 1–50 of 12,483 rows ← 1 2 3 … 250 →

Connection Manager

Keep all your database connections organized in one place. Switch between production, staging, and local environments instantly.

🐘 Production DB

db.myapp.com:5432 · postgres

Connected

🐬 Analytics MySQL

analytics.internal:3306 · mysql

Connected

🍃 MongoDB Atlas

cluster0.mongodb.net · mongo

Idle

⚡ Redis Cache

localhost:6379 · redis

Local

Import & Export

Move data in and out effortlessly. Export to CSV, JSON, or SQL dump. Import from a file or paste data directly — NoctuaDB handles the rest.

📥

Import

CSV · JSON · SQL

📤

Export

CSV · JSON · SQL Dump

Export Progress

74% · 37,291 / 50,000 rows · ~3s remaining

One GUI for
every database

Works with the databases
you already use

Everything you need,
nothing you don't

Ready to dive in?

One GUI forevery database

Works with the databasesyou already use

Everything you need,nothing you don't

Ready to dive in?

One GUI for
every database

Works with the databases
you already use

Everything you need,
nothing you don't