LibreDB Studio libredb.org ONLINE • PostgreSQL
RUN
features.sql
SELECT name, category, summary FROM features ORDER BY category;
17 rows | 3 cols 4ms

Everything you need to master your data

Professional-grade features for developers, DBAs, and data teams.

EDITOR

Monaco SQL IDE

VS Code engine with schema-aware autocomplete, multi-tab workspace, and SQL formatting.

AI

NL2SQL Copilot

Ask questions in plain English and get executable SQL. Schema-aware multi-model AI.

AI

AI Query Safety

Pre-execution risk analysis for destructive queries (DELETE, DROP, TRUNCATE).

AI

AI Query Autopilot

Automated slow query analysis with actionable index and rewrite recommendations.

AI

AI Data Profiler

One-click table profiling with column statistics, null %, cardinality, and AI narrative summaries.

CORE

7+ Databases

PostgreSQL, MySQL, Oracle, SQL Server, SQLite, MongoDB, and Redis with a unified interface.

CORE

Mobile Ready

Touch-optimized responsive UI for tablets and phones. Manage databases anywhere.

DATA

Pro Data Grid

Virtualized rendering, column filtering, inline editing, pivot table, and CSV/JSON export.

DATA

Visual EXPLAIN

Graphical execution plans with AI-powered plain-language explanations and optimization tips.

SCHEMA

Interactive ER Diagrams

Visual schema graph with table relationships, column details, and ReactFlow-powered navigation.

SCHEMA

Database Documentation

Auto-generated searchable data dictionary with AI-powered descriptions and Markdown export.

SECURITY

SSO / Single Sign-On

Vendor-agnostic OIDC authentication with Auth0, Keycloak, Okta, Azure AD. PKCE, role mapping, and provider logout.

SECURITY

Enterprise Security

JWT auth, RBAC, SSL/TLS, SSH Tunnel, transaction control, query cancellation, and SSO support.

SECURITY

Data Masking

Auto-detect sensitive columns (email, phone, SSN, financial). RBAC-enforced with export protection.

TOOLING

ORM Code Generator

Generate TypeScript, Zod, Prisma, Go structs, Python dataclasses, and Java POJOs from live schemas.

TOOLING

Test Data Generator

Schema-aware fake data with 30+ semantic inferences (email, phone, name, address).

TOOLING

DBA Toolkit

Live monitoring, active sessions, one-click VACUUM/ANALYZE/REINDEX, and query auditing.