Home › Databases & Data › Lagaam
Lagaam
Stops an agent's Trino or Pinot query before it runs if it costs too much or reads outside its grant
Topics: Databases
Connect
Review any command before running it. Package names and URLs come from the server's own registry entry.
Package (pypi 0.2.5)
uvx lagaam
Or add to your MCP client config:
{
"mcpServers": {
"lagaam": {
"command": "uvx",
"args": [
"lagaam"
],
"env": {
"LAGAAM_ALLOWED_TABLES": "<YOUR_VALUE>",
"LAGAAM_ALLOW_ALL_TABLES": "<YOUR_VALUE>",
"LAGAAM_ENGINE": "<YOUR_VALUE>",
"TRINO_HOST": "<YOUR_VALUE>",
"TRINO_PORT": "<YOUR_VALUE>",
"TRINO_USER": "<YOUR_VALUE>",
"PINOT_CONTROLLER_URL": "<YOUR_VALUE>",
"PINOT_BROKER_URL": "<YOUR_VALUE>",
"PINOT_USER": "<YOUR_VALUE>",
"PINOT_PASSWORD": "<YOUR_VALUE>",
"LAGAAM_AGENT_NAME": "<YOUR_VALUE>",
"LAGAAM_MAX_SCAN_BYTES": "<YOUR_VALUE>",
"LAGAAM_MAX_ROWS": "<YOUR_VALUE>",
"LAGAAM_MAX_INTERMEDIATE_ROWS": "<YOUR_VALUE>",
"LAGAAM_MAX_RETURNED_ROWS": "<YOUR_VALUE>",
"LAGAAM_QUERY_TIMEOUT": "<YOUR_VALUE>",
"LAGAAM_METADATA_TTL": "<YOUR_VALUE>",
"LAGAAM_AUDIT_LOG": "<YOUR_VALUE>"
}
}
}
}
LAGAAM_ALLOWED_TABLESrequired — Comma list of catalog.schema.table grants; the server will not start without itLAGAAM_ALLOW_ALL_TABLES— true to run with no grant at all: an explicit opt-out, off by defaultLAGAAM_ENGINE— Which adapter to runTRINO_HOST— Trino coordinator hostTRINO_PORT— Trino coordinator portTRINO_USER— Trino userPINOT_CONTROLLER_URL— Pinot controller URLPINOT_BROKER_URL— Pinot broker URLPINOT_USER— Pinot user; unset means no authPINOT_PASSWORDsecret — Pinot password; unset means no authLAGAAM_AGENT_NAME— Identity stamped on the audit trailLAGAAM_MAX_SCAN_BYTES— Scan-bytes budget per query, checked before it runs (default 50 GiB)LAGAAM_MAX_ROWS— Scanned-row estimate budget per query; unset means ungatedLAGAAM_MAX_INTERMEDIATE_ROWS— Rows the engine would build at its widest step, not rows returned, so a LIMIT doesn't lower itLAGAAM_MAX_RETURNED_ROWS— Rows returned to the agent per query, capped at 100000; a bigger LIMIT in the query is lowered to itLAGAAM_QUERY_TIMEOUT— Wall-clock seconds per queryLAGAAM_METADATA_TTL— Metadata cache TTL, secondsLAGAAM_AUDIT_LOG— Audit JSONL file path; unset means stderr
Related servers
MCP Toolbox for Databases
MCP Toolbox for Databases enables your agent to connect to your database.
convex-backend
Convex database integration to introspect tables and functions and run one-off queries.
Nhost
Let your users work with their own data through an AI assistant, limited to what they can see.
baserow
Baserow database integration: search and list tables, and create, read, update and delete rows.
postgres-mcp
Postgres development and operations: performance analysis, tuning and health checks.
Supabase
MCP server for interacting with the Supabase platform
Listed in punkpeye/awesome-mcp-servers (MIT)
Data from the Official MCP Registry