Intelligence · AI Database Assistant

It already knows your environment.
Now you can just ask.

SchemaPulse holds the operational context of every database you run. The assistant reads that context — not a generic index of database documentation — so its answers are about your estate, at this moment, with the evidence attached.

The difference

Not a chatbot with database knowledge.

A general-purpose assistant can explain what innodb_buffer_pool_sizedoes. It cannot tell you that yours dropped from 99.2% to 94.1% at 02:14 this morning, why write traffic moved to that node, or which of two changes the evidence actually supports.

The assistant is useful because of what it can see. Every source below is data SchemaPulse already collects in order to run the platform — the context was there before the assistant was.

Context

What it reads, and what that makes answerable

Metrics
“Why did latency increase on this cluster overnight?”
Query analytics
“Which queries are causing the most load right now?”
Topology & elections
“What happened to this cluster overnight?”
Incidents
“What changed before this incident?”
Alerts
“What should I investigate first?”
Backups & recovery
“Are there any backup or recovery risks in my environment?”
Fleet inventory
“Which databases need attention?”
Configuration
“Is this database at risk?”

Investigation

One question, a real investigation

AI Database Assistantorders-galera · last 24h

What changed before this incident?

Three things changed in the 40 minutes before INC-2291 opened.

At 02:14 UTC orders-galera-1 lost and regained cluster membership, incrementing the Galera conf_id to 5. Write throughput shifted to galera-0, whose innodb_buffer_pool hit rate then fell from 99.2% to 94.1%.

At 02:31 a deployment added an index to orders.line_items. The query SELECT … WHERE order_id IN (…) changed plan and its mean latency rose from 8ms to 340ms.

The latency alert at 02:47 is most consistent with the plan change, not the membership event — the membership change resolved 12 minutes before latency began climbing.

Evidence

Electiongalera-1 · term 5 · 02:14:08Z
Metricbuffer_pool_hit_rate · 99.2% → 94.1%
Querydigest a3f19c · 8ms → 340ms mean
Deployschema change · 02:31:44Z
IncidentINC-2291 · opened 02:47:02Z
Fig. 1The assistant separates correlation from cause and states which of two candidate explanations the evidence supports — rather than naming the most recent change and stopping.

Answers you can check

Every claim links to the record behind it — the metric series, the query digest, the election event, the backup run. Follow any of them into the product and you land on the same data the assistant used. An answer you cannot check is an answer you cannot act on.

Where it stops

The assistant investigates and advises. It does not execute changes against your databases on its own. Where an action can be taken inside SchemaPulse — scheduling a verification restore, opening a maintenance window — it hands you the action rather than taking it.

When it does not know

If the context does not support an answer, it says so and names what it would need. A confident wrong answer about a production database is worse than no answer.

Questions

What teams actually ask

  • Why did latency increase on this cluster overnight?Metrics
  • Which queries are causing the most load right now?Query analytics
  • What happened to this cluster overnight?Topology & elections
  • What changed before this incident?Incidents
  • What should I investigate first?Alerts
  • Are there any backup or recovery risks in my environment?Backups & recovery
  • Which databases need attention?Fleet inventory
  • Is this database at risk?Configuration