SQL & Database Studio

🔒 100% Client-Side

📁 Upload File or Database

⚡ Query Templates:

Select Table:

Record Limit:

Columns to display:

Select a table first to see the available columns.

Filter Condition (Optional WHERE):

Sorting (Optional ORDER BY):

Chart Type:

Label Column (X Axis):

Numeric Values Column (Y Axis):

Query Results

0 record

⚡

Run a SQL query or upload a file to view records.

🛡️ Architecture & Supported Formats

A real Database Manager in the Browser: SQLite, CSV, JSON and Excel

PiTools SQL Studio combines the power of the standard SQLite 3 relational engine compiled to WebAssembly with smart parsers for tabular files, removing the need to install heavy software like Microsoft Access, DBeaver or MySQL/PostgreSQL database servers.

🗄️

SQLite Database (.sqlite, .db)

Load entire binary SQLite files with instant reading of tables, primary keys, foreign keys, indexes and views. Edit the data and export the updated database.

📑

CSV & TSV Files

Smart delimiter detection (comma, semicolon, tab) with automatic column type inference for high-speed relational queries.

📦

JSON & JSON Lines Files

Import arrays of structured JSON objects, converting them on the fly into queryable relational tables with JOIN and aggregate functions.

📊

Excel Spreadsheets (.xlsx)

Each sheet of an Excel file is automatically isolated and loaded as a separate SQL table, so you can compare data across sheets with JOIN queries.