Quickstart

From zero to a queried database in about a minute: create an account, create a database, generate a token, then call it with curl.

1. Create an account

Sign up with an email and password — no credit card, no approval step. You'll land on the Databases dashboard.

2. Create a database

1. Click New database in the top right of the dashboard.
2. Give it a name (for example my-app-db) and confirm.

WamSQLite creates an empty SQLite file instantly, with WAL mode enabled for better concurrent access, and opens it in the Console.

Every database has a UUID — this is the id you'll use in API URLs. You can find it two places:

• Right under the database name at the top of the page.
• In the browser URL: /databases/<uuid>.

3. Run a query in the console

Use the Console tab to run SQL directly in the browser — paste this in and press Run query (or Ctrl/⌘ + Enter):

CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT, email TEXT);
INSERT INTO users (name, email) VALUES ('Ada Lovelace', 'ada@example.com');
SELECT * FROM users;

Each statement runs in order and gets its own result — a row grid for statements that return rows, or an affected-row count for writes.

4. Generate an API token

1. Open the Tokens tab on your database.
2. Click New token and give it a name (for example local-dev).
3. Pick an access level: Read-only for SELECT / EXPLAIN / PRAGMA only, or Read & write for full access including INSERT / UPDATE / DELETE / DDL.
4. Click Create token.

The full token — something like 1|UUoUwvNn158qtWucZ6vjZNqytqZNfafys4NT1gCQ... — is shown once, with a copy button next to it. Save it somewhere safe; WamSQLite never shows it again, and revoking it from the Tokens tab takes effect immediately.

5. Call it with curl

Swap in your own database UUID and token from the steps above:

curl https://wamsqlite.rendovations.com/api/v1/databases/YOUR_DATABASE_UUID/query \
  -H "Authorization: Bearer YOUR_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{"statements": ["SELECT * FROM users"]}'

A successful response looks like this — one entry in results per statement you sent:

{
  "database": "YOUR_DATABASE_UUID",
  "results": [
    {
      "sql": "SELECT * FROM users",
      "columns": ["id", "name", "email"],
      "rows": [{ "id": 1, "name": "Ada Lovelace", "email": "ada@example.com" }],
      "rows_affected": 1,
      "last_insert_id": null,
      "time_ms": 0.42
    }
  ],
  "error": null
}

That's the whole loop: create a database, generate a token, query it from anywhere. See REST API reference for the full request/response shape and error format, or client examples for JavaScript, PHP, and Python.