Results
Read the answer, shape it for the task, and take it with you when you are done.
A query returning rows is usually the beginning of the work, not the end. The result grid is where you read, reshape, compare, and share the answer. These are the main ways SQLly helps with each result set.
Formatting
Per-type display rules for numbers, dates, UUIDs, and text - set once as defaults or overridden per column.
Pivot
Drag fields into rows, columns, and values to cross-tab your data in place.
Chart
Bar, line, scatter, histogram, and pie charts from the result set - with a suggested first chart when the decision model is on.
Row editor
Edit, insert, duplicate, and delete rows through a form built from the table's own schema.
Export
A dozen data formats plus source-code generators, copied or saved from one dialog.
Masking & personal data
Column-name patterns mask sensitive data everywhere - and the decision model can flag personal-looking columns names miss.
Layouts
Arrange multiple result sets as tabs, stacked cards, or a free-form canvas.
Query history
Flip back to the results of your last N runs without re-running them.
JSON & XML cells
SQLly recognises a document in a cell and opens it pretty-printed, highlighted, and searchable.
In this section
- Interactive sample — Try the real result grid in your browser, no installation ceremony required.
- Formatting — Make numbers, dates, ids, and text easier to scan without changing the data beneath them.
- Pivot — Build a cross-tab by moving fields around, then keep the setup as a reusable directive if you like.
- Chart — Turn any result set into a chart without leaving the grid - and start from a suggested setup when the decision model is on.
- Row editor — Edit, insert, duplicate, and delete rows through a form that understands the table you are in.
- Export — Send results onward in the format the next person or tool will actually appreciate.
- Diff two result sets — Put two result sets side by side and see what changed without doing row-by-row detective work.
- JSON & XML cell viewer — Open JSON or XML cells as tidy, explorable structures instead of a wall of punctuation.
- Personal-data detection & masking — Let the decision model flag result columns that look like emails, phones, or card numbers, and mask them in one click.
- Templating language — Describe a transformation once, then let SQLly apply it across the columns that need it.
- Layouts — Give multiple result sets the layout that makes the comparison or review easy.
- Query history — Revisit recent results without rerunning a query just to see what happened last time.