Server Insights is a SQL Editor utility that answers "what's actually happening on this database server right now" without you writing dialect-specific diagnostic queries by hand. Pick a saved credential and it probes connection pool health, active sessions, host resources, and object sizes directly.
The four tabs
Under Utilities → Server Insights, each tab targets a different question:
- Connection Pool — how many connections are open, idle, or waiting against this server right now
- User Connections — active sessions: who's connected, from where, and what they're running
- System Info — host-level RAM, storage, and CPU, plus server uptime
- Table & Index Size — storage footprint per table and index, filterable by name
Table & Index Size doubles as a quick way to find out what's eating disk before you go looking for it manually, and pairs naturally with Utilities → Index Management if a table's indexes turn out to be fragmented.
One credential, dialect-aware probes
Select a saved connection at the top of the modal and Server Insights runs the right introspection query for that engine automatically — you don't need to know the difference between checking session activity on PostgreSQL versus SQL Server versus Oracle. Not every probe exists on every dialect (some engines don't expose comparable system views), so a tab is only shown when the selected connection actually supports it, rather than returning an empty or misleading result.
Why this beats a saved diagnostic query
Most teams already have a folder of "check connections" or "find big tables" scripts they copy between projects, rewritten slightly for every dialect they touch. Server Insights replaces that folder with a UI that already knows the right system tables and views per engine, refreshes on demand, and doesn't drift out of date the way a copied script eventually does. It's read-only by design — there's nothing here that mutates the server, so it's safe to open on production without a second thought.
When to reach for it
A few situations where Server Insights is faster than writing SQL by hand:
- A migration or bulk Data migrate run is slow, and you want to check whether the pool is saturated before assuming the query itself is the problem
- You're about to run something heavy and want a quick read on available memory and CPU first
- You need to know who else is connected before running DDL against a shared environment
- A table is bigger than expected and you want to see its size relative to its indexes
Server Insights lives alongside the rest of the SQL Editor's utilities — Query files, Clone Table, Index Management — all reachable from the same sidebar. See the documentation for the full utilities reference, or install FoxSchema and point it at your own server.
