DBTool DBTool

Powerful Features

Everything you need to view, query, edit, and analyze databases directly in your browser

Core Features

Multiple Databases

Load and work with multiple databases simultaneously. Each database appears as a tab at the top of the interface, making it easy to switch between projects and compare data across different sources.

  • → Load multiple files at once or add databases on-demand
  • → Switch between databases with a single click
  • → Compare schemas and data between databases
  • → Close individual databases without affecting others
ACTIVE TABS
customers.db ACTIVE
products.db ×
orders.csv ×
SQL EDITOR
SELECT name, email, total_spent
FROM customers
WHERE total_spent > 1000
ORDER BY total_spent DESC
Autocomplete available Cmd+Enter to execute

Full SQL Support

Write and execute SQL queries with full SQLite syntax support. Intelligent autocomplete suggests table names, columns, and SQL keywords as you type.

  • → Smart autocomplete for tables, columns, and SQL keywords
  • → Execute with Cmd/Ctrl+Enter keyboard shortcut
  • → Support for SELECT, INSERT, UPDATE, DELETE queries
  • → Query history automatically saved and searchable

Visual Query Builder

Build SQL queries without writing code. Perfect for beginners or quick data exploration. The visual builder generates SQL in real-time as you make selections.

  • → Select tables and columns with dropdown menus
  • → Add multiple filters with various operators
  • → Sort by any column ascending or descending
  • → Generated SQL shown in real-time for learning
TABLE
customers
COLUMNS
name email state
FILTERS
state = "California"
TEMPLATES
Show All Rows
Count Rows
Find Duplicates
Recent Records
Group By Column
+ 3 more templates

Query Templates

8 pre-built query templates for common database operations. Templates automatically adapt to your table and column names, saving time and reducing errors.

  • → Show All Rows - View complete table contents
  • → Find Duplicates - Identify duplicate values
  • → Group By Column - Aggregate data with GROUP BY
  • → Join Tables - Combine data from multiple tables

Data Analysis

Column Statistics

Right-click any column header to view detailed statistics. Get instant insights about your data without writing additional queries.

  • → Total rows, unique values, NULL counts
  • → For numeric columns: min, max, average, sum
  • → Top 5 most common values with frequencies
  • → Statistics calculated instantly from results
COLUMN: price
TOTAL ROWS
1,247
UNIQUE VALUES
342
MAXIMUM
$2,499.99
AVERAGE
$487.23
CHART TYPES
▮▮▮
Bar Chart
╱╲╱
Line Chart
◐
Pie Chart
⋯⋰⋱
Scatter Plot

Data Visualization

Transform query results into interactive charts. Choose from bar, line, pie, doughnut, and scatter charts to visualize trends and patterns.

  • → 5 chart types for different data visualizations
  • → Interactive charts with hover tooltips
  • → Custom titles and axis labels
  • → Dark theme colors for cohesive appearance

Database Comparison

Compare two databases side-by-side to identify schema differences, missing tables, and data discrepancies. Perfect for migration validation and version control.

  • → Compare table structures and schemas
  • → Identify tables unique to each database
  • → Compare row counts and column structures
  • → Visual indicators for matches and differences
COMPARISON SUMMARY
Common Tables 8
Only in DB1 3
Only in DB2 2
Row Count Diff 4

Data Management

Live Editing

Click any cell to edit data directly in the results table. Track changes with visual indicators and save modifications back to the database.

  • • Edit cells inline with click
  • • Visual tracking of changes
  • • Add and delete rows
  • • Download modified database

Query History

All queries are automatically saved with timestamps. Search through your history and re-run previous queries with a single click.

  • • Automatic query saving
  • • Searchable history
  • • One-click re-execution
  • • Numbered for easy reference

Saved Queries

Bookmark frequently-used queries in the sidebar. Organize complex queries and share them across sessions.

  • • Save with custom names
  • • Quick access from sidebar
  • • Edit or delete anytime
  • • Persistent across sessions

Search & Filter

Search across all columns in your result set with instant highlighting. Filter large datasets quickly without writing new queries.

  • • Search all columns at once
  • • Real-time highlighting
  • • Match count display
  • • Keyboard shortcut: Cmd+K

Export Options

Export databases and query results in multiple formats. Convert between formats seamlessly.

  • • SQLite, CSV, TSV, JSON
  • • XML, HTML, SQL Dump
  • • Format conversion support
  • • Copy to clipboard

Resizable Interface

Customize your workspace with resizable panels. Drag edges to adjust sidebar width, query editor height, and column widths.

  • • Resizable sidebars
  • • Adjustable query editor height
  • • Column width customization
  • • Persistent layout preferences

Keyboard Shortcuts

Work faster with powerful keyboard shortcuts

Execute Query
Cmd + Enter
Focus Search
Cmd + K
Toggle History
Cmd + H
Save Query
Cmd + S
Download Database
Cmd + D
Close Sidebar/Modal Esc

Try all features now

Install DBTool and start exploring your databases

Install Extension