Matrix — Custom Data Structures for Your Desktop

#	Name	E-mail	Balance	Active
1	Ana Lima	ana@example.com	R$ 3.200,00
2	Bruno Costa	bruno@example.com	R$ 800,50
3	Carla Melo	carla@example.com	R$ 0,00	—

Everything you need to manage structured data

No database admin skills required. Define your schema visually, edit data in a familiar grid, and let JavaScript handle the rest.

Custom Data Structures

Create Packages and Tables with exactly the fields you need: text, integer, decimal, boolean, date, and datetime. No generic columns, no wasted space.

Spreadsheet-like Editing

Navigate rows, insert and edit records inline, undo changes, and save all at once — just like a spreadsheet, but backed by a real relational database.

Schema Migrations

Add a new field to your table definition and Matrix automatically runs the ALTER TABLE on the next launch. Your data is never lost.

Multiple Environments

Keep separate databases for different projects or clients. Each Environment is an independent folder with its own SQLite file. Switch in one click.

100 % Local

Matrix is a desktop application. All data is stored on your own machine inside a standard SQLite file. No cloud, no account, no subscription.

Multilingual

Interface available in English and Portuguese (pt-BR). Field names and table descriptions support multiple languages out of the box.

Automate with JavaScript

Every environment exposes a built-in JavaScript engine. Write scripts directly in the console or embed them in your workflow — no recompilation, no plugins.

var pkg = env.createPackage("crm");
pkg.setName("pt_BR", "CRM");

var customers = pkg.createTable("customers", {
  name: { pt_BR: "Clientes" },
  fields: [
    { id: "name",    dataType: "TEXT",    required: true, size: 120, label: "Nome" },
    { id: "email",   dataType: "TEXT",    required: true, size: 200 },
    { id: "active",  dataType: "BOOLEAN" },
    { id: "balance", dataType: "NUMERIC", size: 15, decimalPlaces: 2 }
  ]
});

// One-off field afterward: addField returns the table, so it can be chained.
customers.addField({ id: "phone", dataType: "TEXT", size: 30 })
         .addField({ id: "created_at", dataType: "DATETIME" });

pkg.createProgram("seed", 'var c = ClientDataSet("crm.customers"); c.open();')
   .setIcon("database");

// The table already exists in the database — it can be used right away.
var cds = ClientDataSet("crm.customers");
cds.open();

// Print active customers as a report tab
var cds = ClientDataSet("crm.customers");
cds.setFilter([{ field: "active", operator: "=", value: true }]);
cds.setSort("name", true);
cds.setPageSize(0);
cds.open();

Report(ReportType.Markdown,
  "# Active customers\n\n" +
  cds.toMarkdown(["name", "email", { field: "balance", label: "Balance ($)" }]) +
  "\n" + cds.rowsCount() + " customer(s).\n");

cds.close();

// Import customers from an external API
var res = Http.get("https://api.example.com/customers", {
  headers: { "Authorization": "Bearer " + token },
  timeout: 30000
});

if (!res.ok) {
  throw new Error("Failed " + res.status + ": " + res.error);
}

var cds = ClientDataSet("crm.customers");
cds.open();
res.json().forEach(function (c) {
  cds.insert();
  cds.setFieldValue("name", c.name);
  cds.setFieldValue("email", c.email);
  cds.post();
});
cds.saveAllChanges();

// Serve your tables to a website or app as a JSON API
HttpServer.get("/products", function (req) {
  var cds = ClientDataSet("shop.products");
  cds.open();
  return cds; // paginated: {rows, page, pageSize, total}
});

HttpServer.post("/products", function (req) {
  var data = req.json();
  var cds = ClientDataSet("shop.products");
  cds.open();
  cds.insert();
  cds.setFieldValue("name", data.name);
  cds.post();
  cds.saveAllChanges();
  return { status: 201, body: { created: true } };
});

The ClientDataSet() function is available globally in every environment's JavaScript console.

Scripts run inside the application process — no network calls, instant execution.

Use scripts to seed demo data, generate reports, validate entries, or automate repetitive tasks.

Built for real workflows

If you can model it as a table, Matrix can manage it.

CRM

Customer Management

Customers, contacts, deals, follow-ups — structure it exactly the way your team works.

Inventory

Stock Control

Products, units, purchase prices, selling prices, quantities — with decimal precision.

Finance

Personal Finance

Transactions, categories, accounts — run JavaScript to calculate totals and generate reports instantly.

Research

Data Collection

Custom survey responses, field research, scientific datasets — any schema you define.

One app, every desktop

Matrix is built with Qt and distributed as a native binary for each platform. No Electron, no browser — just a fast, lightweight application that feels at home on your operating system.

Windows 10 / 11
macOS 12+
Linux (Ubuntu, Fedora, Arch)

Your data is stored in a standard SQLite file. Open it with any SQLite-compatible tool whenever you need direct access.

Windows 10 / 11 · x64 & ARM64

macOS 12+ · Apple Silicon & Intel

Linux .deb · amd64 & arm64

Download Matrix

Free to download and use. No account, no cloud, no subscription.

Windows .exe installer · x64 Download Also available for ARM64

macOS .dmg installer · Apple Silicon (arm64) Download Also available for Intel (x64)

Linux .deb package · amd64 Download Also available for ARM64

Your data,your structure.