In development

Structa

Build real databases on your Mac.

A professional, native database builder. Design tables, draw forms, write scripts and publish to your network, all from one app. Your data lives in a single .structa file on your Mac. No server. No cloud account.

Get development updates See what's inside

For macOS · Local-first · Works offline

CRM Lite.structa

Tables

Deals

Companies

Contacts

Activities

Forms

Pipeline

Deal Detail

Open pipeline$482k

Won this quarter37

Avg. deal$13.0k

Deal	Company	Value	Stage
Fleet renewal	Northshore Logistics	$42,000	Won
Site licence	Fraser Dental	$18,500	Proposal
Phase 2 build	Coast Mountain Co.	$27,900	Negotiation

Illustration. Interface is in development and will change.

113Built-in formula functions across 12 categories.

50Visual script steps, from navigation to record locks.

18Field types, including first-class file attachments.

1 fileYour whole database, in a .structa package you own.

Get to know Structa

Everything you'd expect from a database builder, and a few things you wouldn't.

Company Text

Value Number

Close date Date

Contract Attachment

Visual schema designer

18 field types (text, numbers, dates, JSON, choices, email, URL and file attachments) with automatic, safe migrations as your design evolves.

If( Stage = "Won";
Value * 0.08;
0 )

A real formula language

113 functions across string, math, date, statistics, crypto, arrays and more, with circular-dependency detection and recursion safety built in.

▶︎

Visual script engine

50 step types for record manipulation, navigation, custom dialogs, control flow and multi-user record locks.

◫

Pixel-perfect forms

A native canvas with snap-to-grid, smart guides and 25 object types: fields, portals, charts and embedded dashboards.

▦

Live dashboards

KPI, chart, recent-records and note tiles with live refresh. Embed a dashboard right inside a form.

✦

AI assistant, your key

Bring your own Anthropic API key, stored in your Keychain. Ask about your schema, draft formulas and generate scripts.

Bring your data

Start from what you already have.

Import FileMaker files directly, along with CSV, JSON, XML, SQL dumps, ODS, DBF and HTML or Markdown tables. Streaming import handles multi-gigabyte files, with pause, resume and cancel.

Recovers tables, fields, records and relationships from FileMaker
Export to CSV, XLSX, JSON or PDF
Print any form, or build multi-page reports

.fmp12CSVJSONXMLSQLODSDBFHTMLMarkdown

Make it behave

Logic where you need it.

Conditional formatting on any form object. Dropdowns that populate from another table. Outbound webhooks that POST every insert, update and delete to Slack, Zapier, n8n or your own endpoint.

# On record commit
Set Variable [ $total ; Sum( Items::Price ) ]
If [ $total > 10000 ]
Show Dialog [ "Needs approval" ]
Set Field [ Status ; "Review" ]
End If

Start fast

Templates, ready in seconds.

Each ships with a dashboard, navigation, scripts and realistic sample data. Customize anything.

📇

CRM Lite

Companies, contacts, deals and activities, with a pipeline dashboard.

📦

Inventory

Products, locations and stock movements with live KPI tiles.

🧾

Invoicing Lite

Clients, invoices, line items and payments, with tax formulas.

🛠

Job Tracking

Projects, tasks, team and time entries with a workload view.

📚

Notes & Collections

Notebooks, notes and tags with full-text search.

Tech specs

In development. Features and requirements may change before release.

Availability: In development for the Mac App Store. Pricing will be announced closer to release.
Platform: macOS, native on Apple Silicon. Browser access to published forms from any device.
Data: Single .structa package containing a SQLite database, project metadata and attachments
Design: 18 field types · 25 form object types · dashboards · reports
Logic: 113 formula functions · 50 script steps · conditional formatting · table-sourced dropdowns · webhooks
Import: FileMaker (.fmp12), CSV, JSON, XML, SQL dumps, ODS, DBF, HTML/Markdown tables
Export: CSV, XLSX, JSON, PDF; print any form
Sharing: Multi-user host mode over LAN; web publishing with HTML routes and JSON API
Security: AES-GCM encryption at rest, Keychain-backed keys, sandboxed
Privacy: No telemetry, no analytics, no account. Network traffic only when you publish, configure webhooks, or use the AI assistant with your own key.

Frequently asked questions

When will Structa be available?

Structa is in active development. We ship when it's ready. email us to hear about betas and the release.

Where does my data live?

In a single .structa file on your Mac: a package containing a SQLite database, your project metadata and any attachments. Move it, back it up, or copy it to another Mac like any other file.

Can I migrate from FileMaker?

Yes. Structa imports .fmp12 files directly and recovers tables, fields, records and relationships. Complex layouts and calculations don't always carry over one-to-one, but your schema and data come through cleanly as a starting point.

Does Structa send anything over the network?

Only when you ask it to: when you start the publishing server, configure an outbound webhook, or use the AI assistant with your own API key. There's no telemetry, analytics or phoning home.

Do I need to expose Structa to the internet?

No. Multi-user sharing is designed for your local network. There is no Structa-hosted relay.

What about iPhone and iPad?

Structa is Mac-first. Anyone with a modern browser can use forms you publish on your network.