Your AI loads and configures the entire database automatically — zero manual setup. SQL Agent gives your AI 38 pre-built tables for jobs, clients, inventory, photos, dispatch, incidents, devices, and communications.
$295 one-time · AI auto-installs and configures everything · Up to 2 machines · No renewal
Zero manual setup. No table creation. No schema copy/paste. No PostgreSQL guesswork. After purchase, load the included auto-config skill and your AI builds the complete SQL Agent database for you.
Get SQL Agent for $295 one-time through secure Stripe checkout. No subscription. No renewal.
Or tell Hermes to load the SQL Agent auto-config skill from your download.
Your AI creates the database, applies all 38 tables, configures extensions, wires credentials, registers memory access, and verifies the install.
The auto-setup skill detects your environment, creates the jarvis_coo database if needed, applies the full schema, sets up indexes/extensions, and logs what it did.
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.
"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?
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.
More data = slower lookups when everything is scattered. SQL Agent keeps records organized so your AI can find the right answer fast.
A regular SQL database stores data. An AI SQL database stores data and lets your AI set it up, read it, write to it, and act on it — in plain English, no technical help needed.
Your AI does everything. One command and the full 38-table database is created, configured, and wired to your AI automatically.
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.
Your AI configures everything. One command loads the auto-setup skill. Your AI creates the database, applies the schema, wires credentials, and verifies the install — zero manual setup.
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.
A pre-built operations database for the records most service businesses need. Includes the auto-config skill your AI needs to load, configure, and verify the entire database automatically.
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.
Complete client records with contact info, service history, and property details. Your AI knows every client, every property, and the full relationship between them.
Track parts from purchase order to installation. Van loading, on-site usage, returns, defects — full lifecycle with photo documentation at every stage.
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.
Three-tier incident management. Priority-based routing, client impact assessment, remote recovery logging. Fleet-wide anomaly detection across all devices.
Full task lifecycle — workstreams, assignments, dependencies, approval workflows, audit trails. Designed to log task changes and make missed handoffs easier to spot.
Smart device inventory with health tracking, firmware management, and staged rollouts. Maintenance windows, readiness scorecards, and predictive risk levels.
Tables for communication notes, service requests, and follow-up timing when you choose to log those records.
Organized business data powers every serious operation. Here's who this is for.
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.
Useful for service businesses, inventory-heavy teams, property teams, and project-based work. Customize fields before using it for regulated records.
Orders, inventory, shipping, returns, and customer history can be organized in one place. "What's our return rate on product X?" — easier to answer.
Consulting, legal, accounting, and agency teams can track clients, projects, hours, deliverables, and invoices in structured records.
Properties, tenants, maintenance requests, vendors, and inspections can be tracked in structured records. "Which properties had maintenance requests this month?" — easier to answer.
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.
Just talk to your AI. SQL Agent keeps the records organized behind the scenes.
AI queries dispatch_jobs table
AI joins job_materials + orders
AI inserts into the right tables
Full-text search on photo captions
AI aggregates from labor + materials
AI builds from jobs + techs + materials
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.
$295 one-time. One SQL Agent license. Up to 2 machines. AI auto-setup included. No renewal or add-ons required.
Your AI loads and configures the entire database automatically — zero manual setup.
Jobs, clients, inventory, dispatch, photos, incidents, devices, tasks, communications, and relationship indexes.
Teaches your AI every table, relationship, query pattern, and operational workflow after setup finishes.
Backup, restore, and migration guides. Move your data when you need to.
No. Your AI writes the SQL for you and now sets up the database for you. Just ask in plain English: "Show me all open jobs" or "What parts did we order this month?" The included skill teaches your AI every table and query pattern.
No. That is the point of the new auto-setup flow. Your AI loads and configures the entire database automatically — zero manual setup. It creates the database if needed, applies the 38-table schema, enables extensions, wires credentials, and verifies everything before you start using it.
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.
SQL Agent starts small and grows as you use it. There are no artificial record limits.
SQL Agent is a $295 one-time license usable on up to 2 machines. Hermes AI uses your license key during setup. There is no renewal charge.