Skip to content
SQL Agent — Ops Database

Give Your AI
a Real Database.

38 pre-built tables for jobs, clients, inventory, photos, dispatch, incidents, devices, and communications. Buy once, install locally, and let your AI use structured records instead of scattered notes.

$295 one-time · Up to 2 machines · No renewal or add-ons required

38
Pre-built tables
8
Business domains
Local
You own the data
Once
Pay one time

Memory Files Don't Scale

Your AI stores everything in scattered files. Names, numbers, job details, client history — all over the place. It works for a while. Then it doesn't.

📄

Flat Files Break

"Find the invoice from the Johnson job last March." Your AI digs through scattered files, misses half the data, makes up the rest. Sound familiar?

🔀

No Relationships

Client → Job → Parts → Photos → Invoice. In flat files, these connections don't exist. Your AI can't trace a part from warehouse to installation to invoice.

🐌

Gets Slower Every Day

More data = slower lookups when everything is scattered. SQL Agent keeps records organized so your AI can find the right answer fast.

Not Just a Database. A Thinking Database.

A regular SQL database stores data. An AI SQL database stores data and lets your AI read it, write to it, and act on it — in plain English, no technical help needed.

🗄️

Regular SQL Database

You write the SQL. Every query, every join, every filter. If you don't know SQL, you're stuck waiting for someone who does.

You design the schema. Weeks of planning before a single record gets stored. Most businesses never get it right the first time.

Passive storage only. The database holds records. You do all the thinking about what those records mean.

Separate tools for insights. You need a BI dashboard, a reporting layer, or a developer to pull meaning out of the data.

Disconnected from operations. Data lives in the database. Decisions happen somewhere else. There's no link between them.

🤖

AI SQL Database

Your AI writes the SQL. Ask "What jobs are still open?" and your AI queries the right tables and returns a real answer — not a guess.

38 tables, pre-built and ready. Jobs, clients, inventory, dispatch, photos, incidents — all structured and connected. Install and start using it today.

Active intelligence. Your AI doesn't just store records — it surfaces what matters. Overdue jobs, low stock, unpaid invoices, missed follow-ups.

Plain English is the interface. No BI tools. No reports to build. Ask in a sentence, get an answer from the real data — not a hallucinated summary of scattered files.

Connected to every decision. Log a job, update a part, flag an incident, create a dispatch — your AI reads and writes from the same source of truth that drives your whole operation.

The difference: a regular database answers the queries you know how to write. An AI SQL database answers the questions you didn't know how to ask.

38 Tables. One Install.

A pre-built operations database for the records most service businesses need. Includes the database and guide your OpenClaw agent needs to start using structured records.

📋

Jobs & Dispatch

Track every job from intake to completion. Assign techs, track status, log materials used, record findings. Full dispatch workflow with clock-in/clock-out and QA verification.

👥

Clients & Properties

Complete client records with contact info, service history, and property details. Your AI knows every client, every property, and the full relationship between them.

📦

Inventory & Orders

Track parts from purchase order to installation. Van loading, on-site usage, returns, defects — full lifecycle with photo documentation at every stage.

📸

Photos & QA

Central photo registry with full-text search on captions. Visual QA inspection tracking. Photo records can be linked to jobs, rooms, devices, and techs, with searchable captions.

🚨

Incidents & NOC

Three-tier incident management. Priority-based routing, client impact assessment, remote recovery logging. Fleet-wide anomaly detection across all devices.

📊

Task Management

Full task lifecycle — workstreams, assignments, dependencies, approval workflows, audit trails. Designed to log task changes and make missed handoffs easier to spot.

🔧

Device Fleet

Smart device inventory with health tracking, firmware management, and staged rollouts. Maintenance windows, readiness scorecards, and predictive risk levels.

📞

Communications

Tables for communication notes, service requests, and follow-up timing when you choose to log those records.

Built For Real Businesses

Organized business data powers every serious operation. Here's who this is for.

🏗️ Service & Field Operations

HVAC, electrical, plumbing, smart home install, property management. Track jobs, dispatch techs, manage inventory, document work with photos. This is where the database was born — managing a 5-person smart home crew doing 40+ jobs/month.

🏥 Healthcare & Clinics

Useful for service businesses, inventory-heavy teams, property teams, and project-based work. Customize fields before using it for regulated records.

📦 E-Commerce & Fulfillment

Orders, inventory, shipping, returns, and customer history can be organized in one place. "What's our return rate on product X?" — easier to answer.

🏢 Professional Services

Consulting, legal, accounting, and agency teams can track clients, projects, hours, deliverables, and invoices in structured records.

🏠 Real Estate & Property

Properties, tenants, maintenance requests, vendors, and inspections can be tracked in structured records. "Which properties had maintenance requests this month?" — easier to answer.

🤖 AI Agent Operations

Running multiple AI agents? Track tasks, assignments, audit logs, approvals, and escalations. The database includes a full multi-agent task management system with workstreams and dependencies.

How Your AI Uses It

Just talk to your AI. SQL Agent keeps the records organized behind the scenes.

💬 Say This

"Show me open jobs"

AI queries dispatch_jobs table

"What parts did we use this week?"

AI joins job_materials + orders

"Add a new client"

AI inserts into the right tables

"Find all photos from the Smith job"

Full-text search on photo captions

"What's our revenue this month?"

AI aggregates from labor + materials

"Create a dispatch card for Monday"

AI builds from jobs + techs + materials

✨ Plain-English Workflow

Ask for what you need: open jobs, missing parts, client history, photos, invoices, service issues, or follow-up tasks. SQL Agent keeps the business records connected so your AI can answer from the source instead of guessing from scattered notes.

By the Numbers

38
Pre-built tables
8
Business domains covered
FTS
Full-text search built in
Records — no file size limits
< 1ms
Query response time

Everything's Included

$295 one-time. One SQL Agent license. Up to 2 machines. No renewal or add-ons required.

The SQL App

Automated setup, all 38 business tables, and OpenClaw AI instructions.

OpenClaw AI Guide

Instructions your OpenClaw agent can follow: every table, every relationship, and query examples for every domain.

AI Skill File

Drop-in guide that teaches your AI how the business records are organized. Works with OpenClaw.

Backup & Migration Tools

Backup, restore, and migration guides. Move your data when you need to.

Frequently Asked Questions

Do I need to know SQL?

No. Your AI writes the SQL for you. Just ask in plain English: "Show me all open jobs" or "What parts did we order this month?" The included SKILL.md teaches your AI every table and query pattern.

What if my business doesn't match these tables?

The 38 tables cover the most common business operations. The structure can be extended later if your business needs more fields or tables. You're not locked into a rigid template.

How big can the database get?

SQL Agent starts small and grows as you use it. There are no artificial record limits.

How is it licensed?

SQL Agent is a $295 one-time license usable on up to 2 machines. OpenClaw AI uses your license key during setup. There is no renewal charge.

Give Your AI a Real Database

Stop asking your AI to dig through scattered notes. Give it SQL Agent and watch it actually work.

License SQL Agent — $295 one-time

License key issued after purchase · Includes the app + OpenClaw AI guide

OpenClaw AI handles setup from the included guide.