PixelOkay
Local-only · No database accessDeveloper tools ↗
Tools
VISUAL QUERY DESIGNER · SQL GENERATOR

SQL Query Builder

Select columns, connect tables, create conditions and export readable SQL. Your schema and work stay in this browser. Back up important queries as JSON files.

SELECT03 dialectsPostgreSQL · MySQL · SQLite
01

Select columns

Choose what the query returns and optionally summarize values.

02

Join tables

Connect related data using explicit column pairs.

03

Filter rows

Only include records that match your conditions.

Assign conditions to Group 1, 2 or 3. Conditions within a group use the first selector.
04

Group & summarize

Aggregate results and filter groups with HAVING.

Group by

Having

05

Sort & limit

Order output rows and cap the result set.

A query without typing SQL.

Start with a base table, pick columns on the left, and join related tables when you need columns from elsewhere. Add filters, grouping and ordering, then review the SQL preview on the right.

  1. Design the schema. Use the demo or import definitions from your own database.
  2. Select output columns. COUNT, SUM, AVG, MIN and MAX are supported for appropriate types.
  3. Connect tables. Set each join's left/right keys; a joined table is added only once.
  4. Add conditions. Values are represented as parameters by default.
  5. Generate & export. Copy SQL and bindings or download a project backup.

Security and limitations

Generated SQL is a SELECT statement only. This tool does not connect to a database, inspect credentials or execute SQL. Parameter placeholders must be bound in your application's database driver; never concatenate untrusted user input into executable SQL. This builder supports up to three WHERE condition groups with AND/OR connectors, but does not support arbitrary-depth nesting, subqueries, CTEs, window functions, arbitrary expressions, or self-joins.

Untrusted project and schema JSON is validated, never evaluated as JavaScript. This editor stores autosaved draft data in your browser; export a JSON backup before clearing site data.

Using SQL Query Builder

Define or import a schema, choose output columns and connect supported joins. Add filters, grouping and ordering, then inspect the generated SQL and parameter order. Export SQL and bindings separately and keep JSON for continued editing.

This generates SELECT statements without connecting to or executing against a database. It does not verify live schema, permissions, performance or results. Filters use a bounded two-level grouping model; self-joins, CTEs, subqueries and window functions are unsupported. Bindings may contain sensitive values. Browser drafts are not encrypted or synced, and numeric precision is bounded.

Choose SQL text, parameter bindings or an editable query

Practice: draft a query against a fictional schema

  1. Define a fictional table with an identifier and text column.
  2. Select output columns and add a supported filter with a fictional parameter value.
  3. Inspect SQL and binding order, then save JSON and export only the files appropriate for the recipient.

This is an authored query-planning exercise, not an executed query or verified database result.

SQL builder questions

Does the tool connect to a database or verify query performance?

No. It generates statements from a local schema without execution. Live schema, permissions, result correctness and performance are not verified.

Can I use self-joins, subqueries or arbitrary nested filters?

No. Filters use a bounded two-level grouping model; self-joins, CTEs, subqueries and window functions are unsupported. Review the supported query and precision limits, and keep sensitive bindings separate from SQL.

Related tools