Connected apps

You can connect an AI assistant — or another app — to read and update your tables on your behalf, through a secure connection that you approve.

Connect Claude

An assistant connects to DataWasi's MCP server, at https://datawasi.app/mcp. The address is also under User settings → Connected apps, with a button to copy it.

1. In Claude (claude.ai or the desktop app), open Settings → Connectors, add a custom connector and paste the address.
2. Claude opens DataWasi: sign in and approve what it may do.
3. Ask Claude about your tables — "how much did we spend on fuel in March?" — or tell it what to add.

In Claude Code, add it from a terminal, then type /mcp in Claude Code to sign in:

claude mcp add --transport http datawasi https://datawasi.app/mcp

Any other assistant that connects to MCP servers and signs in through the browser takes the same address.

How it works

When an app asks to connect, you sign in and approve exactly what it may do: read your data, add or edit records, or change a table's structure. Nothing happens until you approve it, and an app can only ever act within the access you grant.

What an assistant can do

Within the access you approve, an assistant can:

• See your tables and their fields — your own and the ones shared with you. Archived tables only when it asks for them, and only to read.
• Search and read records, and add them up: totals, counts and averages, grouped by any field.
• Read a table through its saved views: ask for "Big groceries" and it reads that view's own filters, not its guess at them.
• Add, edit and delete records. A record it deletes goes to the table's trash; it can see what's there and bring a record back, one you deleted included.
• Add many records at once — a pile of receipts, the rows of a spreadsheet — and say which it couldn't add, and why.
• Read a record's history and comments — who changed the amount, what someone said about it — and comment on it in your name. A @mention in its comment notifies that person, as yours would; where a table's comments are turned off, it can't comment.
• Create tables, rename them, and add and change their fields, when you let it change a table's structure.
• Add choices to an Options field — a new category, a new status — with that same access. The choices already there, and the records that hold them, stay as they are; renaming or removing one is yours to do, in the field's settings.
• Read the files attached to a record and attach new ones (see Files, below).

When an assistant builds your tables

Give an assistant that may change your tables' structure a pile of invoices, or describe what you keep track of, and it builds tables that hold all of it without you spelling that out: a customer or a product that comes up again and again gets its own table, and each record points to it; an invoice's lines stay inside the invoice. A plain value, like a currency or a status, stays a choice on the record instead of becoming another table — and when the amounts come in several currencies, each amount follows that choice, so every record shows its own.

It can lay the records out too — sections side by side, the total large — so they read and print like the papers they come from (see record layouts).

Manage connections

Open User settings → Connected apps to see everything you've authorized. Disconnect an app to revoke its access immediately.

How far write access goes, per table

When you grant an app write access, the same screen lets you decide how far that goes on each table you can write to: create, update and delete (the default), create and update, or only create — for a ledger an assistant should be able to add to but never alter. Reading is never limited by this, and tables you create later get everything.

Each connection's limits show under User settings → Connected apps. Like the rest of what you approved, changing them means disconnecting the app and connecting it again.

Files

An assistant can read the files attached to a record and attach new ones. Reading a record gives it a link to download each file, which works for 15 minutes: long enough to open an invoice's PDF or save a photo, and the link left behind in the conversation soon stops working. To attach a file, it uploads it straight to your storage and then adds it to the record.

Both need an assistant that can run commands on a computer, like Claude Code: the file travels over its own connection, never through the chat. Attaching counts as editing the record, so it takes write access and a table where the connection may update records, and the field's allowed file types and the 100 MB limit apply just as they do for you. An assistant can't remove a file.

Personal access tokens

Some things can't sign in through a browser: a Zapier, Make or n8n step, a script that runs every night, a machine you control. For those, create a personal access token — a long-lived key that stands in for you on the API, without the approval screen. A token works on the API only, not on the MCP server: to connect an assistant, use the address above.

1. Open User settings → Connected apps and choose New token.
2. Give it a name that says what uses it, decide whether it may only read or also create, update and delete records — and, if it writes, how far that goes on each table, exactly like a connected app — and pick when it expires: in 90 days, a year, or two.
3. Copy the token from the next page. It's shown only that once; if you lose it, revoke it and create another.

Tokens appear in the same list as your connected apps, with their name, what they may do, when they were last used and when they expire. Revoke one at any time; whatever used it loses access immediately.

Pushing records in from outside

A token can add records to a table as well as read it. Besides creating and updating records by id, the API has an upsert call: send the field that identifies the record in the other system — an invoice number, an order id — and the values, and it updates the record that matches or creates one when none does. It can also add a record from a sentence: send what someone said or typed — "500 for fuel at Ancap, today" — and the AI fills in the table's fields from it, the way it reads a photo (it counts toward the account's AI allowance). The page that shows a new token has an example call to start from.