Qrulla Docs

Design and compare

Design

The table designer, the entity-relationship diagram, the visual query builder and the test data generator.

Design a table

Right-click a table → “Design”, or “New table…” on a database or schema. The designer has:

  • Columns: name, type (as the engine writes it, with its length: varchar(80), numeric(12,2)), whether it takes NULL, default value, whether it's part of the primary key and whether it's auto-numbered. A text default goes in quotes: 'active'.
  • Indexes: name, columns and whether it's unique.
  • Foreign keys: the column, the table and column it points to, and what to do on delete.
  • Changes (SQL): the exact statements that will run.
  • Current SQL: how the table is created on the server now.

“Save” shows the changes and asks you to confirm. What deletes data (for example, removing a column) shows in red.

ER diagram

Right-click a database or a schema → “ER diagram”. It shows the tables with their columns and the relations between them: the crow's foot is “many”, the bar “one” and the circle “may have none”.

  • Drag tables to arrange them, drag the background to move around and use the wheel to zoom. “Rearrange” lays them out on its own and “Fit” frames everything.
  • Click a relation to move its ends to another side of the table or add bends (double-click the line).
  • Theme: automatic, dark, blue, brown, teal or pink.
  • Export as a PNG image, a PDF document or an SVG vector image.

Edit the model

With “Edit” you can add tables, columns and foreign keys in the diagram. “Apply to the database…” compares the diagram with the database and runs only what changes; a renamed name is renamed in the database and its data stays.

“Generate script…” creates the SQL of the whole model for another engine, for example to take a MySQL design to PostgreSQL, with the list of what changes in the translation.

Design a query

Right-click a database or a schema → “Design query” builds a SELECT without typing it:

  1. Add tables from the list. They join on their own with the ones already there through their foreign keys.
  2. Tick the columns. Each can get a name, a summary (count, sum, average, minimum, maximum) and a sort order.
  3. Adjust the joins (matching only, all from the left, from the right or all) and add filters.
  4. “No repeats” and “Most rows” finish the query.

Below you see the SQL being built; “Open in the editor” takes it to an editor to run it or keep writing.

Test data

Advanced plan. Right-click a database or a schema → “Test data…” fills tables with realistic data:

  • Pick the tables and how many rows for each.
  • For each column, what fills it: first names, last names, emails, phones, cities, addresses, companies, dates, numbers in a range, yes/no, words, UUIDs, one from a list, or keys from another table. You can ask for values without repeats and a share of empties.
  • “Preview” shows a sample without writing anything.
  • The seed makes the same data come out every time.

Parent tables are filled first, and foreign keys use keys that exist. Rows are only added; nothing is deleted.

Something missing or unclear? Write to support@qrulla.com.