Free SQL Client: What DbSchema Community Edition Includes

DbSchema Community Edition is a free SQL client that covers four jobs: connect to any supported database, reverse-engineer the schema, work in interactive ER diagrams, and write SQL in the editor. It is free permanently and needs no signup. Offline design, schema synchronization, documentation export and the visual query builder are Pro.

DbSchema Community Edition at a Glance

Community Edition is not a time-limited trial and not a cut-down installer. The installation kit is the same for every edition, and the licence decides which menus open. DbSchema 10.5.0 is the current build. Install it without a licence key and you are in Community; the 15-day Pro trial runs on the same binaries and can be extended by another 15 days.

• Free permanently, for as many people as you like, with no signup and no account.
• Connect over JDBC to any of 100+ SQL and NoSQL databases.
• Reverse-engineer a live schema into interactive ER diagrams you can rearrange and edit.
• Create tables, columns and relations, and push them to the connected database.
• Write and run SQL in an editor whose autocomplete knows your tables and columns.

Free vs Paid: What Community Edition Covers

Every row below is read off the edition table on the DbSchema purchase page, checked on 24 August 2026. Where that table has no row for a criterion, this one says so instead of guessing.

The last row is the one the edition table cannot settle: there is no team-features row on it. What is verified is narrower. Community is licensed for as many people as you like, so seats are not the constraint; but saving the design model to a file is Pro, and Git versioning of a schema depends on that file existing.

Two other rows are easy to misread. Saving query results to a file is part of the SQL editor and is not the same thing as Design offline / save to file, which means the .dbs design model. And relational data browse means opening several tables side by side over their foreign keys, which is not the SQL editor's own result grid.

The line falls at the point where the schema stops being something you read and starts being something you ship. Querying and exploring any database is free forever. Wanting a diff against another database, or an interactive HTML5 documentation file to hand to someone, or a versioned model, puts you in Pro. Schema synchronization and documentation export both sit on the Pro side of that line.

A Pro licence is $294.00 perpetual for business use and $196.00 for personal use, both in US dollars. dbschema.com serves US dollars, euros or Romanian lei depending on where the page is loaded from, so confirm your own currency on the purchase page before buying.

Download DbSchema and Connect for the First Time

The DbSchema download page carries one installer per platform and asks for nothing in return. No registration is required, and there is no account to create before the client will start.

1. Download the installer for your platform: exe, zip, msi or an ARM-64 exe on Windows, dmg or tgz on macOS, sh, deb, rpm or gzip on Linux.
2. Run it and start DbSchema. With no licence key entered, you are in Community Edition.
3. Choose Connect to database, pick your engine from the driver list, then fill in host, port, database, user and password.
4. Let DbSchema fetch the JDBC driver if it does not already hold it, and test the connection.
5. Accept the reverse-engineering dialog. DbSchema reads the catalog and lays the tables out as an ER diagram.
6. Open the SQL editor from the toolbar. The connection you just made is already selected.

Be clear about one thing before you start. Community Edition works against the live database: you connect, you read the schema, you run SQL. The offline design model - the .dbs file you keep in Git and edit with no database in reach - is a Pro capability. Close DbSchema in Community and the next session reconnects and reads the schema again, rather than loading it from a saved file.

Run Your First Query: A Worked Example

Start with two tables, so there is a relationship to look at. Paste this into the SQL editor and run it against a scratch database.

CREATE TABLE customers (
  customer_id INT PRIMARY KEY,
  name        VARCHAR(120) NOT NULL,
  country     VARCHAR(2)
);

CREATE TABLE orders (
  order_id    INT PRIMARY KEY,
  customer_id INT REFERENCES customers(customer_id),
  order_date  DATE,
  total       DECIMAL(10,2)
);

Refresh the diagram and both tables appear, joined by a connector line drawn from the foreign key you just declared. That is the part a plain text editor cannot give you: the relationship is visible before you write a single SELECT. The same reverse-engineering step turns an existing production database into a readable ER diagram.

Now query across both tables:

SELECT c.name,
       c.country,
       COUNT(o.order_id) AS orders,
       SUM(o.total)      AS revenue
FROM customers c
JOIN orders o ON o.customer_id = c.customer_id
WHERE o.order_date >= DATE '2026-01-01'
GROUP BY c.name, c.country
ORDER BY revenue DESC;

Press Execute Query in the editor toolbar - it runs the selected text, or the statement at the cursor - and the result lands in the grid underneath. Two things are worth noticing while you type it. The join follows the same foreign key you can see on the diagram, and the filter is what keeps the scan off the whole table. Autocomplete offers the c. and o. column names because DbSchema has already read the catalog.

If the statement is wrong, the error comes back in the execution log under the editor and, with Ignore Errors off, the run stops there. Nothing in this example needs a licence key. Every step above runs in the free Community Edition.

Writing SQL in the Free Editor

The SQL editor is one of the capabilities the edition table unlocks in Community, and it is more than a text box with a Run button. Three of its behaviours are what make the free client useful for reading a database you did not build.

Real-Time Diagram Updates

The diagram and the model you are working on stay in step. Edit a table on the canvas and the change lands in the model straight away, with the generated DDL there to read before anything is committed. Run DDL from the editor instead and Schema > Refresh Model from Database - or Selective Refresh, F5 - brings the diagram back in line, so you never have to scroll raw DDL to see the shape of what you are querying.

• Which table connects to which
• Which foreign keys are declared
• How the schema is structured as a whole

On a large database this is the fastest way to find out what you are actually querying, and it is the reason the free client is worth installing even when you already have a SQL console.

Autocomplete and Syntax Highlighting

Autocomplete in the DbSchema SQL editor draws on the connected schema, not just on SQL keywords. Press Ctrl+Space and it suggests table names, column names, keywords and functions. Syntax highlighting and inline validation catch the typos before you run them.

Instant SQL Generation from Diagrams

Design a table in the diagram and DbSchema writes the SQL for it. Right-click a table or a relation and the generated script is there to copy, inspect or edit before it runs. It is a fast way to learn what a given DDL statement produces, because you can build the shape first and read the statement afterwards.

Reading and Exporting Query Results

Query results in DbSchema arrive in a grid rather than a text dump, and the grid does more than display. Three behaviours matter here, and one of them is regularly confused with a Pro feature.

Explore Your Data in the Result Grid

Results appear as a spreadsheet-style table under the editor. For most databases the data returned in the result pane can be edited inline: double-click a cell, change the value, commit when you are finished. This is the SQL editor's own grid - the multi-table Relational Data Editor that walks foreign keys between panes is a separate Pro capability.

Save Results to a File

Click the save button in the result pane and DbSchema re-runs the query, streaming the whole result straight to a file. A dataset too large to hold on screen still lands intact. Results export to CSV, Excel or JSON. Keep this apart from the design model: saving the .dbs model file is the Pro capability, and the two have nothing to do with each other.

Run Groovy and JavaScript in the SQL Editor

Switch the editor mode from the drop-down and the same pane runs Groovy or JavaScript against the connection. A script gets the active JDBC connection, the DbSchema model and an output stream bound as variables, so it can read data, write it back, or print a report into the script result pane. Built-in code samples sit in the Help menu.

Note the boundary. Scripting inside the SQL editor is one thing; packaging those scripts into Database management applications is its own row in the edition table and needs Pro.

Other Free SQL Clients, Compared

Four other free clients turn up on the same shortlist. Each vendor's own page was read on 24 August 2026, and where a page does not state something, the table leaves the cell out rather than filling it in from memory.

What separates DbSchema Community here is the pairing: the diagram is reverse-engineered from the live schema and sits next to the editor, so the structure and the query are in the same window. Each of the others is genuinely better at something. DBeaver Community reaches further as a general SQL IDE and is open source. pgAdmin is the better PostgreSQL administration console. HeidiSQL keeps every feature free with no paid edition above it. DbVisualizer Free gives you SSH tunnelling and connection management at no cost, though its data editor and query builder are Pro. If the diagram is the whole point, the free ER diagram tools round-up compares them on that criterion alone.

Download the Free SQL Client

Download DbSchema and connect it to your own database. Everything in this article - the connection, the reverse-engineered diagram, the SQL editor, the result grid, the exports and the Groovy scripting - runs in the free Community Edition, permanently and without an account. If you then need offline design, schema synchronization or HTML5 documentation, the Pro trial turns them on in the same installation. If the language itself is the problem, the SQL syntax guide covers every statement used above.

Sources

1. DBeaver Community
2. DBeaver downloads and PRO features
3. pgAdmin
4. HeidiSQL
5. DbVisualizer pricing