SQLite Query Builder

📋 Define Your Tables

No tables defined yet. Click "Add Table" to get started!

📊 Table Data Viewer

No tables with data yet. Add a table and insert rows to view data here.

🔍 SELECT Fields

Choose which columns to include in your query results

Add Field:

No fields selected

🔗 JOIN Tables

Link tables by specifying relationships between columns

No joins defined

🎯 WHERE Filters

Add conditions to filter your results

No filters defined

⚙️ Additional Options

GROUP BY:

ORDER BY:

LIMIT:

📝 Generated SQL

-- Your query will appear here --

⚡ Execute SQL Query

SQL Query:

📊 Query Results

No results yet. Execute a query to see results here.

💡 Sample Queries

Load sample database to see example queries

📚 How to Use SQLite Query Builder

1. Define Your Tables

Start by creating tables in the Table Designer tab. Add columns with their data types. You can also load a sample database to experiment with pre-populated data.

2. Build Your Query

Use the Query Builder tab to visually construct your SQL query:

SELECT: Choose which columns to retrieve
JOIN: Link tables by specifying matching columns
WHERE: Add filters to narrow down results
GROUP BY / ORDER BY: Organize your results

3. Execute & Test

Go to the Execute & Test tab to run your query against the database. You can edit the SQL directly or load it from the query builder.

🔗 JOIN Types

INNER JOIN - Returns only matching rows from both tables
LEFT JOIN - Returns all rows from left table, matching rows from right
RIGHT JOIN - Returns all rows from right table, matching rows from left
FULL OUTER JOIN - Returns all rows when there's a match in either table

🎯 WHERE Operators

= Equal to | != Not equal to | > Greater than | < Less than | LIKE Pattern matching | IN Match any in list

💾 Sample Database

The sample database includes three tables: users, orders, and products. Use them to practice joins and complex queries!

Ready SQLite Query Builder v1.0