server_activity
Inspect live database sessions, running statements, waits, blocking sessions, and locks to diagnose contention; read-only and prioritized by waiting or long-running work.
Instructions
What the database server is doing now: its sessions (user, database, client, state, the statement running and for how long, what it waits for and the sessions blocking it) and the locks held or waited for, as in the PlatypusDB admin tab; sessions that wait or run first, 50 by default (limit, up to 200). The statements are other people's: credentials and the values of sensitive columns are masked, and long ones cut at 500 characters. PostgreSQL, MySQL, MariaDB and SQL Server; read-only: nothing is cancelled or ended. A missing privilege is said so.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"connection": "<connection>"
},
"name": "server_activity"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Entries returned at most: sessions for `server_activity` (50 by default, up to 200), statements for `top_queries` (20 by default, up to 100). | |
| connection | Yes | The connection's name, as `list_connections` shows it. |