ConnectionsAIO fleet API

AIO fleet API

Degraded

REST API · api.aiophones.io

Health

Degraded

Last check

12m ago

Latency

1.8 s

Used by

1 agents · 3 reports

Connection details

Host

api.aiophones.io

Engine

HTTPS / JSON

Database

aio-fleet

SSL mode

Verify full

Pool size

5 connections

Read-only role

tandem_reader

Owner

Priya Raman

Secret location

Workspace vault · billing/primary

Credentials are encrypted at rest and never rendered in the UI or sent to a model.

Exposed datasets

4 approved

billing.revenue_daily

1.2M rows · 14 columns · updated 2m ago

approved

billing.invoices

842K rows · 22 columns · updated 2m ago

approved

billing.refunds

18K rows · 11 columns · updated 5m ago

approved

billing.subscriptions

42K rows · 19 columns · updated 2m ago

approved

Approved query templates

All templates

revenue_by_team_range

start_date, end_date, granularity · 5,000 rows · 20 s

approved

delayed_orders

since_hours, min_age_hours · 500 rows · 15 s

approved

mrr_movement

month · 1,000 rows · 20 s

approved

Recent queries

Time	Template	Rows	Duration	Status
09:00:01	revenue_by_team_range	812 rows	1.2 s	Delivered
08:05:12	mrr_movement	42 rows	0.8 s	Delivered
07:30:44	revenue_by_team_range	1,204 rows	1.4 s	Delivered
06:12:03	delayed_orders	23 rows	0.4 s	Delivered

Latency

p95 · 24h

1.8 s

within target

12h agonow

Safety checks

TLS verified with full certificate chain

Read-only database role

No destructive statements permitted

Credentials rotated 12d ago

Row limits enforced per template

Used by

Suncoast Ops Analyst2 templates

Revenue reports3 reports

Finance sync1 schedule

Manage agent access

Alerting

Connection failure

Page owner immediately

Latency > 500ms

Notify #infra

Schema drift

Block queries until review

Remove connection

Reports and schedules using it will pause, not fail silently.

AIO fleet API

Search Tandem