Kiyi 0.6.0

Kiyi 0.6.0 finds messy data and helps you fix it, keeps your charts side by side on dashboards, and lets you edit a query's result in place. If you already have Kiyi, it updates itself and asks before restarting.

New

Data quality. Every table has a new Quality tab, and Check data on the Overview checks the whole database. Kiyi points out:

• duplicate and copied rows,
• one value spelled several ways ("Istanbul", "istanbul ", "İstanbul"),
• stray spaces and empty text,
• invalid emails, outliers and negative amounts,
• dates in the future or far in the past,
• columns that are never filled.

Each finding says how many rows it touches. Most come with a fix, like "Use 'Istanbul' everywhere" or "Trim the spaces", that shows its SQL first and runs in one transaction. Show the rows opens the table filtered to the rows behind a finding. The check only reads: up to 50,000 rows per table, on your computer.

Try it on the sample database (welcome screen → Try the sample database), which has a little mess in it on purpose.

Dashboards. In the SQL editor, switch a result to Chart and choose Add to dashboard. A dashboard keeps several charts side by side:

• Charts re-run when the dashboard opens, on Refresh, or every few minutes while it's on screen.
• Make a chart full width, move it, or open its SQL.
• Dashboard queries can only read, so refreshing never changes data.
• Dashboards travel with exported connections.

Edit query results. When a query reads one table and shows its key, for example SELECT id, name, email FROM customers WHERE country = 'Germany', its result can be edited like the table itself:

• Changed cells are highlighted, and the status bar shows Discard and Save.
• Save updates each row by its key. On production, the UPDATE statements are shown for review first.
• Joins, groupings, DISTINCT, computed and binary columns stay read-only.

Fixed

• Your work, kept: a change made just before the window closed or reloaded is no longer lost. Before, the older copy in Kiyi's folder could win on the next start, dropping a new dashboard or an open query tab.
• Data quality: a value with a trailing space is reported once, as extra spaces, not also as a second spelling.

Download

• macOS: Kiyi_0.6.0_aarch64.dmg (Apple Silicon) or Kiyi_0.6.0_x64.dmg (Intel). Signed and notarized.
• Windows: Kiyi_0.6.0_x64-setup.exe. Not code-signed yet: if SmartScreen asks, choose More info → Run anyway.
• Linux: Kiyi_0.6.0_amd64.AppImage or Kiyi_0.6.0_amd64.deb.

Full changelog: v0.5.0...v0.6.0