OpenRows

Data and views

• Workspaces, bases and tables, each table stored as its own Postgres table.
• 30 field types: text, long text with rich formatting, numbers, currency, percent, duration, rating, dates and times, single and multiple select, checkbox, email, URL, phone, barcode, attachments, users, buttons, auto numbers, created/modified time and by, and AI fields.
• Linked records, lookups, rollups, counts and a formula language with an editor that completes, type-checks and previews as you write.
• Grid (virtualized, with copy/paste, fill and undo), kanban, calendar, gallery, timeline (Gantt, with dependencies), list (nested by a self link) and form views, each with filters, sorts, groups, row colors and hidden fields; personal and locked views.

Collaboration and sharing

• Real-time editing with presence (who is on the view, their selected cell).
• Roles per workspace and base (owner, creator, editor, commenter, read-only), plus edit permissions per table and field.
• Record comments with @mentions and reactions, in-app and email notifications with digests.
• Share links for views and whole bases (optional password and email-domain limits), embeds, and public forms with conditional fields and Cloudflare Turnstile.

Automation and extensibility

• Automations: triggers on records created, updated or matching a condition, schedules, form submissions, incoming webhooks and button clicks; actions that create, update and find records, send email, HTTP requests and Slack messages, and (opt-in) run scripts in a locked-down container. A visual builder with test runs and run history.
• Scripts that run against a base in a sandboxed browser worker.
• Extensions: a panel of sandboxed apps beside your views (chart, print view and URL preview are built in), written with the @openrows/blocks SDK.

API and integrations

• REST API v1 in the shape of Airtable's Web API (typecast, upserts, filterByFormula), with an OpenAPI document and a reference page in the app (docs/api/v1.md).
• Personal access tokens with scopes and per-base grants, OAuth apps with PKCE (docs/api/oauth.md), per-token and per-base rate limits.
• Webhooks with signed, retried deliveries and a delivery log (docs/api/webhooks.md).
• A remote MCP endpoint at /mcp and a stdio MCP server for AI agents (docs/api/mcp.md).
• Packages in this repository: the typed JavaScript SDK (@openrows/sdk), the MCP server (@openrows/mcp-server), n8n community nodes (@openrows/n8n-nodes-openrows) and the extensions SDK (@openrows/blocks).