User Guide

Installation

1. Install DBTool from the Chrome Web Store
2. Click the DBTool icon in your browser toolbar
3. The extension popup will open, ready to load a database

Loading Your First Database

There are three ways to load a database:

• Drag & Drop: Drag any database file onto the drop zone
• File Picker: Click the drop zone to browse and select a file
• Remote URL: Enter a direct URL to a database file hosted online

Main Toolbar

• New Query: Opens a new SQL query tab
• Templates: Access pre-built query templates
• Export: Export entire database or selected tables
• Info: View database metadata and statistics

Left Sidebar

Navigate your database structure:

• Click any table to view its contents
• Expand tables to see columns and indexes
• Right-click for context menu options
• Search bar to filter tables by name

Query Editor

• Syntax highlighting for SQL
• Auto-completion for table and column names
• Press Ctrl+Enter (Windows/Linux) or Cmd+Enter (Mac) to run query
• Multiple tabs for different queries

Basic SELECT Query

SELECT * FROM users LIMIT 10;

Retrieves first 10 rows from the users table

Filtering Data

SELECT name, email FROM users
WHERE created_at > '2024-01-01'
ORDER BY name ASC;

Filter users created after a specific date and sort by name

Joining Tables

SELECT users.name, orders.total
FROM users
JOIN orders ON users.id = orders.user_id
WHERE orders.status = 'completed';

Combine data from multiple tables using JOIN

Aggregations

SELECT category, COUNT(*) as count, AVG(price) as avg_price
FROM products
GROUP BY category
HAVING count > 5;

Calculate statistics using aggregate functions

Column Statistics

Right-click any column header to view:

• Unique value count
• Null/empty value percentage
• Min/max values for numeric columns
• Average, median, standard deviation
• Most common values

Data Visualization

After running a query, click "Visualize" to create:

• Bar charts for categorical data
• Line charts for time series
• Pie charts for proportions
• Scatter plots for correlations

Search & Filter

Use the search box above results to:

• Filter rows by text match
• Use wildcards: %search%
• Click column headers to sort
• Multi-column sorting with Shift+Click

Export Options

Click the "Export" button in the toolbar:

• SQLite (.db): Export as SQLite database file
• CSV: Export current table or query results
• JSON: Export as JSON array
• SQL Script: Export as SQL CREATE and INSERT statements
• Excel (.xlsx): Export to Excel spreadsheet

Selective Export

Export only what you need:

• Select specific tables to export
• Export query results directly
• Choose to include or exclude schema

Database Won't Load

• Ensure the file is a valid database format (SQLite, CSV, JSON, Excel)
• Check that the file isn't corrupted or empty
• For remote URLs, verify the file is publicly accessible and uses HTTPS
• Try reloading the extension

Query Errors

• Check SQL syntax - error messages will indicate the issue
• Verify table and column names are correct
• Use the Visual Query Builder if you're unsure about SQL syntax
• Try the query templates for common operations

Performance Issues

• Large databases (>100MB) may take time to load
• Use LIMIT clauses to reduce result set size
• Create indexes for frequently queried columns
• Close unused query tabs to free up memory