Prototype · Preview: every server in the official registry, synced every 30 minutes. Sign in with Google to write reviews.Prototype · updated every 30 min
PopNx MCPMCP servers for people who use AI · explained in plain words

Lagaam

by lagaam-aiversion 1.0.0i★ 1iRuns on your computerRepository ↗
Registry nameio.github.lagaam-ai/lagaam

How to install

What it does

Stops an agent's Trino or Pinot query before it runs if it costs too much or reads outside its grant

  • Connects Runs on your computer
  • Account or key Needs TRINO_PASSWORD, TRINO_JWT, PINOT_PASSWORD · 1 setting to fill in (LAGAAM_ALLOWED_TABLES)
  • Category Other

Why it ranks here

Lists are ordered by a usage score (out of 100) built from these parts

Popularity4/80GitHub stars or weekly downloads: the larger counts 60, the smaller 20
Freshness12/12Full marks for a release or code change within 30 days
Still answering0/8The cloud endpoint answered at the last check
Usage score16/100

Quality: Passed 3/3 basic checks (shown, not used for ordering) · Momentum: No data yet (Used only on the Trending tab)

Install

Pick the AI app you use, then copy the settings.

Let your AI install it with one sentence

Please install Lagaam. Follow https://mcp.popnx.com/i/lagaam-ai-lagaam.md, show me the commands and wait for my OK before running them.

Paste it into an AI that can work on your computer (such as Claude Code or Cursor). It reads our steps, shows you the commands and waits for your OK. No key, no sign-up. · See the full text your AI reads

Passed 3/3 checks · Runs on your computer · ✓ Commands checked Nov 14, 2026

First: which AI do you use?

Pick your app and the steps appear below.

Works with Claude, with some setup first

You need a Lagaam key (create it on the maker’s site) · 1 setting(s) to fill in (LAGAAM_ALLOWED_TABLES) · Install Python (uv) on your computer first (one time) · Only the Claude desktop app (Windows or Mac), not the web or phone

Let AI install it

Copy this message into a Claude chat. The AI checks your computer, tells you which file it will change, and waits for your OK every time.

Please install the MCP server Lagaam for Claude on this computer, in this order: 1) Check uv with uv --version. If it is missing, tell me to install it from https://docs.astral.sh/uv/getting-started/installation/; do not install it yourself. 2) Use only this config (already checked by PopNx MCP): { "mcpServers": { "lagaam": { "command": "uvx", "args": [ "lagaam" ], "env": { "LAGAAM_ALLOWED_TABLES": "your-value", "TRINO_PASSWORD": "your-value", "TRINO_JWT": "your-value", "PINOT_PASSWORD": "your-value" } } } } 3) Tell me the full path of the file you will change, or the command you will run, and wait for my OK. 4) For TRINO_PASSWORD, TRINO_JWT, PINOT_PASSWORD, LAGAAM_ALLOWED_TABLES, leave "your-value" in place and tell me to paste the real value myself into the file or the app’s field. Never ask me to type a key in chat. 5) Do what we agreed, then check that the Lagaam tools really show up.

This message has no key in it. If a key is needed, the AI will ask you to paste it yourself into the file or the app’s field.

  1. Install uv (if you don’t have it)

    Already installed? Check first · Open Terminal, type this command and press Enter

    uv --version
    • A version number such as uv … = installed, skip this step
    • "command not found" (on Windows: "is not recognized") = not installed yet, or installed but Terminal needs to be closed and reopened
    How to open Terminal

    Mac: press ⌘ + Space, type Terminal, press Enter

    Windows: open Start, type Windows PowerShell, then Open

    Not installed: uv has no click-through installer. Copy the one-line command for your system (macOS or Windows) from uv’s official page into Terminal · no separate Python install needed; uv downloads it when required

    Open the uv download page ↗

    When it’s done, close Terminal, open it again and run the same command. You should see a version number: uv --version

    Install once; it works for everything that needs uv

  2. Sign up and create a Lagaam key

    Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.

    Open the Lagaam site ↗

  3. Fill in 1 setting(s)

    These are program settings, not keys. No sign-up needed; fill them in as the maker describes.

    • LAGAAM_ALLOWED_TABLES Comma list of catalog.schema.table grants; the server will not start without it

    Descriptions are as written by the maker.

  4. Open the Claude desktop app’s settings file

    SettingsDeveloperEdit Config

  5. Paste these settings and save the file

    {
      "mcpServers": {
        "lagaam": {
          "command": "uvx",
          "args": [
            "lagaam"
          ],
          "env": {
            "LAGAAM_ALLOWED_TABLES": "your-value",
            "TRINO_PASSWORD": "your-value",
            "TRINO_JWT": "your-value",
            "PINOT_PASSWORD": "your-value"
          }
        }
      }
    }

    Paste the key only into the app’s field, never into a chat or to anyone

  6. Quit Claude and open it again

  7. Try it

    Use Lagaam and tell me what you can do for me, then show me one thing

    ✓ If Claude says it is using Lagaam or shows a Lagaam tool in the answer, you are connected

18 optional setting(s) (works without them)

The command above works without these. Add them only if you want to change something, following the maker’s description.

  • LAGAAM_ALLOW_ALL_TABLES true to run with no grant at all: an explicit opt-out, off by default
  • LAGAAM_ENGINE Which adapter to run · default trino
  • TRINO_HOST Trino coordinator host · default localhost
  • TRINO_PORT Trino coordinator port · default 8080
  • TRINO_USER Trino user · default lagaam
  • TRINO_HTTP_SCHEME http or https; unset means https once a password or JWT is set, else http
  • TRINO_VERIFY TLS cert check: true, false, or the path of a CA bundle (PEM) · default true
  • PINOT_CONTROLLER_URL Pinot controller URL · default http://localhost:9000
  • PINOT_BROKER_URL Pinot broker URL · default http://localhost:8000
  • PINOT_USER Pinot user; unset means no auth
  • LAGAAM_AGENT_NAME Identity stamped on the audit trail · default anonymous
  • LAGAAM_MAX_SCAN_BYTES Scan-bytes budget per query, checked before it runs (default 50 GiB) · default 53687091200
  • LAGAAM_MAX_ROWS Scanned-row estimate budget per query; unset means ungated
  • LAGAAM_MAX_INTERMEDIATE_ROWS Rows the engine would build at its widest step, not rows returned, so a LIMIT doesn't lower it · default 50000000
  • LAGAAM_MAX_RETURNED_ROWS Rows returned to the agent per query, capped at 100000; a bigger LIMIT in the query is lowered to it · default 1000
  • LAGAAM_QUERY_TIMEOUT Wall-clock seconds per query · default 300
  • LAGAAM_METADATA_TTL Metadata cache TTL, seconds · default 300
  • LAGAAM_AUDIT_LOG Audit JSONL file path; unset means stderr

Descriptions are as written by the maker.

Menu names checked against Anthropic’s help page on Nov 11, 2026 · your screen may differ slightly by app version

ChatGPT cannot connect Lagaam yet

Lagaam runs on your computer, but ChatGPT can only connect servers that run on the web

What you can do instead

A · Use an app that can connect Lagaam

  • You need a Lagaam key (create it on the maker’s site) · 1 setting(s) to fill in (LAGAAM_ALLOWED_TABLES) · Install Python (uv) on your computer first (one time) · Only the Claude desktop app (Windows or Mac), not the web or phone
  • You need a Lagaam key (create it on the maker’s site) · 1 setting(s) to fill in (LAGAAM_ALLOWED_TABLES) · Install Python (uv) on your computer first (one time)
  • You need a Lagaam key (create it on the maker’s site) · 1 setting(s) to fill in (LAGAAM_ALLOWED_TABLES) · Install Python (uv) on your computer first (one time)
  • You need a Lagaam key (create it on the maker’s site) · 1 setting(s) to fill in (LAGAAM_ALLOWED_TABLES) · Install Python (uv) on your computer first (one time)

B · Others in Other that work with ChatGPT

Picked from the most used in the same category, only ones that connect by address with no key

Works with Claude Code, with some setup first

You need a Lagaam key (create it on the maker’s site) · 1 setting(s) to fill in (LAGAAM_ALLOWED_TABLES) · Install Python (uv) on your computer first (one time)

Let AI install it

Copy this message into a Claude Code chat. The AI checks your computer, tells you which file it will change, and waits for your OK every time.

Please install the MCP server Lagaam for Claude Code on this computer, in this order: 1) Check uv with uv --version. If it is missing, tell me to install it from https://docs.astral.sh/uv/getting-started/installation/; do not install it yourself. 2) Use only this config (already checked by PopNx MCP): claude mcp add --scope user lagaam --env LAGAAM_ALLOWED_TABLES=your-value --env TRINO_PASSWORD=your-value --env TRINO_JWT=your-value --env PINOT_PASSWORD=your-value -- uvx lagaam 3) Tell me the full path of the file you will change, or the command you will run, and wait for my OK. 4) For TRINO_PASSWORD, TRINO_JWT, PINOT_PASSWORD, LAGAAM_ALLOWED_TABLES, leave "your-value" in place and tell me to paste the real value myself into the file or the app’s field. Never ask me to type a key in chat. 5) Do what we agreed, then check that the Lagaam tools really show up.

This message has no key in it. If a key is needed, the AI will ask you to paste it yourself into the file or the app’s field.

  1. Install uv (if you don’t have it)

    Already installed? Check first · Open Terminal, type this command and press Enter

    uv --version
    • A version number such as uv … = installed, skip this step
    • "command not found" (on Windows: "is not recognized") = not installed yet, or installed but Terminal needs to be closed and reopened
    How to open Terminal

    Mac: press ⌘ + Space, type Terminal, press Enter

    Windows: open Start, type Windows PowerShell, then Open

    Not installed: uv has no click-through installer. Copy the one-line command for your system (macOS or Windows) from uv’s official page into Terminal · no separate Python install needed; uv downloads it when required

    Open the uv download page ↗

    When it’s done, close Terminal, open it again and run the same command. You should see a version number: uv --version

    Install once; it works for everything that needs uv

  2. Sign up and create a Lagaam key

    Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.

    Open the Lagaam site ↗

  3. Fill in 1 setting(s)

    These are program settings, not keys. No sign-up needed; fill them in as the maker describes.

    • LAGAAM_ALLOWED_TABLES Comma list of catalog.schema.table grants; the server will not start without it

    Descriptions are as written by the maker.

  4. Open Terminal

    Mac: press Command+Space and type Terminal · Windows: open PowerShell

  5. Paste this command and press Enter

    claude mcp add --scope user lagaam --env LAGAAM_ALLOWED_TABLES=your-value --env TRINO_PASSWORD=your-value --env TRINO_JWT=your-value --env PINOT_PASSWORD=your-value -- uvx lagaam

    Replace “your-value” with your key before pressing Enter

    Paste the key only into the app’s field, never into a chat or to anyone

  6. Type /mcp in Claude Code

    You should see Lagaam listed as connected

  7. Try it

    Use Lagaam and tell me what you can do for me, then show me one thing

    ✓ If Claude Code says it is using Lagaam or shows a Lagaam tool in the answer, you are connected

18 optional setting(s) (works without them)

The command above works without these. Add them only if you want to change something, following the maker’s description.

  • LAGAAM_ALLOW_ALL_TABLES true to run with no grant at all: an explicit opt-out, off by default
  • LAGAAM_ENGINE Which adapter to run · default trino
  • TRINO_HOST Trino coordinator host · default localhost
  • TRINO_PORT Trino coordinator port · default 8080
  • TRINO_USER Trino user · default lagaam
  • TRINO_HTTP_SCHEME http or https; unset means https once a password or JWT is set, else http
  • TRINO_VERIFY TLS cert check: true, false, or the path of a CA bundle (PEM) · default true
  • PINOT_CONTROLLER_URL Pinot controller URL · default http://localhost:9000
  • PINOT_BROKER_URL Pinot broker URL · default http://localhost:8000
  • PINOT_USER Pinot user; unset means no auth
  • LAGAAM_AGENT_NAME Identity stamped on the audit trail · default anonymous
  • LAGAAM_MAX_SCAN_BYTES Scan-bytes budget per query, checked before it runs (default 50 GiB) · default 53687091200
  • LAGAAM_MAX_ROWS Scanned-row estimate budget per query; unset means ungated
  • LAGAAM_MAX_INTERMEDIATE_ROWS Rows the engine would build at its widest step, not rows returned, so a LIMIT doesn't lower it · default 50000000
  • LAGAAM_MAX_RETURNED_ROWS Rows returned to the agent per query, capped at 100000; a bigger LIMIT in the query is lowered to it · default 1000
  • LAGAAM_QUERY_TIMEOUT Wall-clock seconds per query · default 300
  • LAGAAM_METADATA_TTL Metadata cache TTL, seconds · default 300
  • LAGAAM_AUDIT_LOG Audit JSONL file path; unset means stderr

Descriptions are as written by the maker.

Menu names checked against Anthropic’s help page on Nov 11, 2026 · your screen may differ slightly by app version

Works with Cursor, with some setup first

You need a Lagaam key (create it on the maker’s site) · 1 setting(s) to fill in (LAGAAM_ALLOWED_TABLES) · Install Python (uv) on your computer first (one time)

Let AI install it

Copy this message into a Cursor chat. The AI checks your computer, tells you which file it will change, and waits for your OK every time.

Please install the MCP server Lagaam for Cursor on this computer, in this order: 1) Check uv with uv --version. If it is missing, tell me to install it from https://docs.astral.sh/uv/getting-started/installation/; do not install it yourself. 2) Use only this config (already checked by PopNx MCP): { "mcpServers": { "lagaam": { "command": "uvx", "args": [ "lagaam" ], "env": { "LAGAAM_ALLOWED_TABLES": "your-value", "TRINO_PASSWORD": "your-value", "TRINO_JWT": "your-value", "PINOT_PASSWORD": "your-value" } } } } 3) Tell me the full path of the file you will change, or the command you will run, and wait for my OK. 4) For TRINO_PASSWORD, TRINO_JWT, PINOT_PASSWORD, LAGAAM_ALLOWED_TABLES, leave "your-value" in place and tell me to paste the real value myself into the file or the app’s field. Never ask me to type a key in chat. 5) Do what we agreed, then check that the Lagaam tools really show up.

This message has no key in it. If a key is needed, the AI will ask you to paste it yourself into the file or the app’s field.

  1. Install uv (if you don’t have it)

    Already installed? Check first · Open Terminal, type this command and press Enter

    uv --version
    • A version number such as uv … = installed, skip this step
    • "command not found" (on Windows: "is not recognized") = not installed yet, or installed but Terminal needs to be closed and reopened
    How to open Terminal

    Mac: press ⌘ + Space, type Terminal, press Enter

    Windows: open Start, type Windows PowerShell, then Open

    Not installed: uv has no click-through installer. Copy the one-line command for your system (macOS or Windows) from uv’s official page into Terminal · no separate Python install needed; uv downloads it when required

    Open the uv download page ↗

    When it’s done, close Terminal, open it again and run the same command. You should see a version number: uv --version

    Install once; it works for everything that needs uv

  2. Sign up and create a Lagaam key

    Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.

    Open the Lagaam site ↗

  3. Fill in 1 setting(s)

    These are program settings, not keys. No sign-up needed; fill them in as the maker describes.

    • LAGAAM_ALLOWED_TABLES Comma list of catalog.schema.table grants; the server will not start without it

    Descriptions are as written by the maker.

  4. Click this button to open Cursor

    Open in Cursor

    Cursor asks you to confirm; click Install

  5. Fill in your key

    In the Lagaam settings, TRINO_PASSWORD, TRINO_JWT, PINOT_PASSWORD, LAGAAM_ALLOWED_TABLES is empty; add your key and save

    Paste the key only into the app’s field, never into a chat or to anyone

  6. Open the AI chat in Cursor in Agent mode

  7. Try it

    Use Lagaam and tell me what you can do for me, then show me one thing

    ✓ If Cursor says it is using Lagaam or shows a Lagaam tool in the answer, you are connected

18 optional setting(s) (works without them)

The command above works without these. Add them only if you want to change something, following the maker’s description.

  • LAGAAM_ALLOW_ALL_TABLES true to run with no grant at all: an explicit opt-out, off by default
  • LAGAAM_ENGINE Which adapter to run · default trino
  • TRINO_HOST Trino coordinator host · default localhost
  • TRINO_PORT Trino coordinator port · default 8080
  • TRINO_USER Trino user · default lagaam
  • TRINO_HTTP_SCHEME http or https; unset means https once a password or JWT is set, else http
  • TRINO_VERIFY TLS cert check: true, false, or the path of a CA bundle (PEM) · default true
  • PINOT_CONTROLLER_URL Pinot controller URL · default http://localhost:9000
  • PINOT_BROKER_URL Pinot broker URL · default http://localhost:8000
  • PINOT_USER Pinot user; unset means no auth
  • LAGAAM_AGENT_NAME Identity stamped on the audit trail · default anonymous
  • LAGAAM_MAX_SCAN_BYTES Scan-bytes budget per query, checked before it runs (default 50 GiB) · default 53687091200
  • LAGAAM_MAX_ROWS Scanned-row estimate budget per query; unset means ungated
  • LAGAAM_MAX_INTERMEDIATE_ROWS Rows the engine would build at its widest step, not rows returned, so a LIMIT doesn't lower it · default 50000000
  • LAGAAM_MAX_RETURNED_ROWS Rows returned to the agent per query, capped at 100000; a bigger LIMIT in the query is lowered to it · default 1000
  • LAGAAM_QUERY_TIMEOUT Wall-clock seconds per query · default 300
  • LAGAAM_METADATA_TTL Metadata cache TTL, seconds · default 300
  • LAGAAM_AUDIT_LOG Audit JSONL file path; unset means stderr

Descriptions are as written by the maker.

Menu names checked against Cursor’s help page on Nov 11, 2026 · your screen may differ slightly by app version

Works with VS Code, with some setup first

You need a Lagaam key (create it on the maker’s site) · 1 setting(s) to fill in (LAGAAM_ALLOWED_TABLES) · Install Python (uv) on your computer first (one time)

Let AI install it

Copy this message into a VS Code chat. The AI checks your computer, tells you which file it will change, and waits for your OK every time.

Please install the MCP server Lagaam for VS Code on this computer, in this order: 1) Check uv with uv --version. If it is missing, tell me to install it from https://docs.astral.sh/uv/getting-started/installation/; do not install it yourself. 2) Use only this config (already checked by PopNx MCP): { "servers": { "lagaam": { "type": "stdio", "command": "uvx", "args": [ "lagaam" ], "env": { "LAGAAM_ALLOWED_TABLES": "your-value", "TRINO_PASSWORD": "your-value", "TRINO_JWT": "your-value", "PINOT_PASSWORD": "your-value" } } } } 3) Tell me the full path of the file you will change, or the command you will run, and wait for my OK. 4) For TRINO_PASSWORD, TRINO_JWT, PINOT_PASSWORD, LAGAAM_ALLOWED_TABLES, leave "your-value" in place and tell me to paste the real value myself into the file or the app’s field. Never ask me to type a key in chat. 5) Do what we agreed, then check that the Lagaam tools really show up.

This message has no key in it. If a key is needed, the AI will ask you to paste it yourself into the file or the app’s field.

  1. Install uv (if you don’t have it)

    Already installed? Check first · Open Terminal, type this command and press Enter

    uv --version
    • A version number such as uv … = installed, skip this step
    • "command not found" (on Windows: "is not recognized") = not installed yet, or installed but Terminal needs to be closed and reopened
    How to open Terminal

    Mac: press ⌘ + Space, type Terminal, press Enter

    Windows: open Start, type Windows PowerShell, then Open

    Not installed: uv has no click-through installer. Copy the one-line command for your system (macOS or Windows) from uv’s official page into Terminal · no separate Python install needed; uv downloads it when required

    Open the uv download page ↗

    When it’s done, close Terminal, open it again and run the same command. You should see a version number: uv --version

    Install once; it works for everything that needs uv

  2. Sign up and create a Lagaam key

    Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.

    Open the Lagaam site ↗

  3. Fill in 1 setting(s)

    These are program settings, not keys. No sign-up needed; fill them in as the maker describes.

    • LAGAAM_ALLOWED_TABLES Comma list of catalog.schema.table grants; the server will not start without it

    Descriptions are as written by the maker.

  4. Click this button to open VS Code

    Open in VS Code

    VS Code asks you to confirm; click Install

  5. Fill in your key

    In the Lagaam settings, TRINO_PASSWORD, TRINO_JWT, PINOT_PASSWORD, LAGAAM_ALLOWED_TABLES is empty; add your key and save

    Paste the key only into the app’s field, never into a chat or to anyone

  6. Open the AI chat in VS Code in Agent mode

  7. Try it

    Use Lagaam and tell me what you can do for me, then show me one thing

    ✓ If VS Code says it is using Lagaam or shows a Lagaam tool in the answer, you are connected

18 optional setting(s) (works without them)

The command above works without these. Add them only if you want to change something, following the maker’s description.

  • LAGAAM_ALLOW_ALL_TABLES true to run with no grant at all: an explicit opt-out, off by default
  • LAGAAM_ENGINE Which adapter to run · default trino
  • TRINO_HOST Trino coordinator host · default localhost
  • TRINO_PORT Trino coordinator port · default 8080
  • TRINO_USER Trino user · default lagaam
  • TRINO_HTTP_SCHEME http or https; unset means https once a password or JWT is set, else http
  • TRINO_VERIFY TLS cert check: true, false, or the path of a CA bundle (PEM) · default true
  • PINOT_CONTROLLER_URL Pinot controller URL · default http://localhost:9000
  • PINOT_BROKER_URL Pinot broker URL · default http://localhost:8000
  • PINOT_USER Pinot user; unset means no auth
  • LAGAAM_AGENT_NAME Identity stamped on the audit trail · default anonymous
  • LAGAAM_MAX_SCAN_BYTES Scan-bytes budget per query, checked before it runs (default 50 GiB) · default 53687091200
  • LAGAAM_MAX_ROWS Scanned-row estimate budget per query; unset means ungated
  • LAGAAM_MAX_INTERMEDIATE_ROWS Rows the engine would build at its widest step, not rows returned, so a LIMIT doesn't lower it · default 50000000
  • LAGAAM_MAX_RETURNED_ROWS Rows returned to the agent per query, capped at 100000; a bigger LIMIT in the query is lowered to it · default 1000
  • LAGAAM_QUERY_TIMEOUT Wall-clock seconds per query · default 300
  • LAGAAM_METADATA_TTL Metadata cache TTL, seconds · default 300
  • LAGAAM_AUDIT_LOG Audit JSONL file path; unset means stderr

Descriptions are as written by the maker.

Menu names checked against VS Code’s help page on Nov 11, 2026 · your screen may differ slightly by app version

Other apps that use MCP, such as Windsurf, Zed or Gemini CLI, each add servers differently. See how in the app list.

See every app that uses MCP →

JSON settings are under “For developers” below

Stuck? Ask people who use Lagaam💬 Discussion →
For developers: Terminal commands and JSON settings

Installed on your computer

Claude Code

claude mcp add --scope user lagaam --env LAGAAM_ALLOWED_TABLES=your-value --env TRINO_PASSWORD=your-value --env TRINO_JWT=your-value --env PINOT_PASSWORD=your-value -- uvx lagaam

Claude Desktop (claude_desktop_config.json)

{
  "mcpServers": {
    "lagaam": {
      "command": "uvx",
      "args": [
        "lagaam"
      ],
      "env": {
        "LAGAAM_ALLOWED_TABLES": "your-value",
        "TRINO_PASSWORD": "your-value",
        "TRINO_JWT": "your-value",
        "PINOT_PASSWORD": "your-value"
      }
    }
  }
}

Cursor (~/.cursor/mcp.json)

{
  "mcpServers": {
    "lagaam": {
      "command": "uvx",
      "args": [
        "lagaam"
      ],
      "env": {
        "LAGAAM_ALLOWED_TABLES": "your-value",
        "TRINO_PASSWORD": "your-value",
        "TRINO_JWT": "your-value",
        "PINOT_PASSWORD": "your-value"
      }
    }
  }
}

VS Code (mcp.json)

{
  "servers": {
    "lagaam": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "lagaam"
      ],
      "env": {
        "LAGAAM_ALLOWED_TABLES": "your-value",
        "TRINO_PASSWORD": "your-value",
        "TRINO_JWT": "your-value",
        "PINOT_PASSWORD": "your-value"
      }
    }
  }
}

Values you fill in

  • LAGAAM_ALLOWED_TABLES required env
    Comma list of catalog.schema.table grants; the server will not start without it
  • LAGAAM_ALLOW_ALL_TABLES env
    true to run with no grant at all: an explicit opt-out, off by default
  • LAGAAM_ENGINE env
    Which adapter to run
  • TRINO_HOST env
    Trino coordinator host
  • TRINO_PORT env
    Trino coordinator port
  • TRINO_USER env
    Trino user
  • TRINO_PASSWORD secret required env
    Password for TRINO_USER; unset means no login. Not with TRINO_JWT
  • TRINO_JWT secret required env
    JWT to log in with instead of a password; unset means no login
  • TRINO_HTTP_SCHEME env
    http or https; unset means https once a password or JWT is set, else http
  • TRINO_VERIFY env
    TLS cert check: true, false, or the path of a CA bundle (PEM)
  • PINOT_CONTROLLER_URL env
    Pinot controller URL
  • PINOT_BROKER_URL env
    Pinot broker URL
  • PINOT_USER env
    Pinot user; unset means no auth
  • PINOT_PASSWORD secret required env
    Pinot password; unset means no auth
  • LAGAAM_AGENT_NAME env
    Identity stamped on the audit trail
  • LAGAAM_MAX_SCAN_BYTES env
    Scan-bytes budget per query, checked before it runs (default 50 GiB)
  • LAGAAM_MAX_ROWS env
    Scanned-row estimate budget per query; unset means ungated
  • LAGAAM_MAX_INTERMEDIATE_ROWS env
    Rows the engine would build at its widest step, not rows returned, so a LIMIT doesn't lower it
  • LAGAAM_MAX_RETURNED_ROWS env
    Rows returned to the agent per query, capped at 100000; a bigger LIMIT in the query is lowered to it
  • LAGAAM_QUERY_TIMEOUT env
    Wall-clock seconds per query
  • LAGAAM_METADATA_TTL env
    Metadata cache TTL, seconds
  • LAGAAM_AUDIT_LOG env
    Audit JSONL file path; unset means stderr

Descriptions are as written by the maker.

These settings are generated from the maker’s registry entry. If the README says otherwise, follow the README.

At a glance

Downloads per weeki
122/wk
Licencei
Apache-2.0
Connection
Runs on your computer
Latest versioni
1.0.0
Categoryi
Other
Published to registryi
Nov 6, 2026
Code last changedi
Nov 6, 2026
Maker
lagaam-ai
Packages
pypi: lagaam
Website
github.com
Registry status
Active

Which apps can use it

Based on how this server connects and on each app’s own docs, checked Nov 10, 2026.

Run on your computer in

ClaudeGooseLM StudioMsty StudioCherry StudioCursorVS Code + GitHub CopilotVisual StudioWindsurf (Devin Desktop)ZedKiroClineContinueJetBrains AI AssistantClaude CodeCodex CLIGemini CLIOpenCodenodecodeWarpLibreChatRaycast

All apps, with pros and cons →

Related guides

What it can do

Runs on your computer; the tool list appears in your AI app after you install it.

Basic checksi

We check information anyone can see; we have not read the code. Checks that do not apply are left out of the count. · Checked Nov 19, 2026

  • ✓ Pass

    Maker matches the repo

    The registry name was verified with the GitHub account lagaam-ai, which owns the repo

  • ✓ Pass

    Still maintained

    Code last changed 13 days ago

  • ✓ Pass

    Has a licence

    Uses Apache-2.0

  • – Not applicable

    Endpoint responds

    This one runs on your computer; there is no internet endpoint

  • – Not applicable

    Sign-in with OAuth

    Runs on your computer and uses local settings instead

  • … Not checked yet

    No hidden instructions in tool descriptions

    Runs on your computer; we can only read tool lists from internet endpoints

Published vulnerabilities (OSV.dev)

No entries on OSV.dev for lagaam@1.0.0

Checks only this package version, not every dependency · checked Nov 15, 2026

What we check → · JSON

Makers: ask for a re-check or report wrong info
For makers: add a badge to your README

If you made this, paste this code into your README. The badge links back to this page.

[![Featured on PopNx MCP](https://mcp.popnx.com/badge/lagaam-ai-lagaam.svg)](https://mcp.popnx.com/en/servers/lagaam-ai-lagaam)

Discussion

Ask, share a tip or report that it does not work. Sorted by what people marked helpful.

No posts yet. Be the first to ask or share.

Posts here are written by users, not the PopNx team.

Sign in to post

User reviews

No reviews yet

Sign in to write a review

Compared with others in Otheri

  • More stars than 86% of the other 20749 servers in this category
  • Published to the registry more recently than 78% of the other 20749 servers in this category
  • Basic checks equal to or better than 99% of the other 20749 servers in this category

Compared with every active server in this category in the registry. Stars count only when the publisher owns the repo.

Common questions

Is Lagaam safe?

It passed 3 of 3 applicable basic checks. We have not read the code. Before adding a key or token, see what access the server asks for and use a key with only the permissions you need.

What keys or codes does it need?

You need to fill in: TRINO_PASSWORD, TRINO_JWT, PINOT_PASSWORD

Does it run on my computer or in the cloud?

It runs on your computer. Your AI app starts it when needed, and data does not pass through the maker’s servers (unless it calls an online service itself).

Is it still maintained?

The GitHub repo last changed 13 days ago, and the latest version (1.0.0) reached the registry 13 days ago.

Which apps can use it?

Apps that support MCP, such as Claude Desktop, Claude Code, Cursor and VS Code. You also need Python (uv) on your computer.

What can I use instead?

In the same category: World Monitor, openstatus, Oh My Posh Validator, Strata, Jitsu

Similar alternatives

Same category, other makers, commands already checked. Official ones first, then by stars.

Reading a card:↓ Downloads per weeki★ GitHub starsiThree pillars: reviews · checks · usageiUpdated = latest version published to the registryi

World Monitor

Real-time global intelligence on conflict, markets, energy, trade, shipping and cyber. 100 tools.

by koala73Widely used★ 90.9KUpdated 3 days ago

Runs in the cloud✓ service owner · worldmonitor.app

openstatus

Manage monitors, status pages, incidents and maintenances in your openstatus workspace.

by openstatusHQWidely used★ 9.3KUpdated 2 months ago

Runs in the cloud✓ service owner · openstatus.dev

Oh My Posh Validator

Validate oh-my-posh configurations and segment snippets against the official schema.

by JanDeDobbeleerWidely used★ 23.8K Stars for the whole repoUpdated 30 days ago

Runs in the cloud✓ service owner · ohmyposh.dev

Strata

MCP server for progressive tool usage at any scale (see https://klavis.ai)

by Klavis-AIGrowing★ 5.8KUpdated 14 months ago

Runs in the cloudRepo archived✓ klavis.ai

Jitsu

Manage Jitsu data pipelines: destinations, streams, connections, functions, live events.

by jitsucomWidely used★ 5.1KUpdated 4 months ago

Runs in the cloud✓ service owner · jitsu.com
Compared with similar ones
This one
Lagaam
World MonitoropenstatusOh My Posh ValidatorStrataJitsu
Runs whereInstalls on your computerRuns in the cloud, nothing to installRuns in the cloud, nothing to installRuns in the cloud, nothing to installRuns in the cloud, nothing to installRuns in the cloud, nothing to install
Needs a keyYesNoNoNoNoNo
Add with + in ClaudeNoNoNoNoNoNo
Basic checks3/34/44/44/41/44/4
LicenseApache-2.0AGPL-3.0AGPL-3.0MITApache-2.0MIT
PriceNo cost listed in the registryNo cost listed in the registryNo cost listed in the registryNo cost listed in the registryNo cost listed in the registryNo cost listed in the registry

README from the maker

Open the README

Copied from the maker’s repo as written. PopNx MCP has not reviewed or endorsed it. HTML, images and scripts are removed. Links lead off this site.

One agent query shouldn't stall everyone's Trino. On a shared cluster, a missing partition filter or an accidental cross join doesn't cost you a bill — it costs everyone else their queries. Lagaam is an MCP server that sits between your AI agents and your lakehouse (Trino and Apache Pinot): every query is schema-grounded, priced from the engine's own plan *before* it runs, checked against a budget, and audited — and the bad one is refused before it runs, with a fix the agent can act on.

*Real session, real Trino, nothing mocked — reproduce it with uv run --project server python examples/demo.py.*

*Real session, real Pinot 1.5.1 realtime table, nothing mocked — reproduce it with uv run --project server python examples/demo_pinot.py.*

The problem

Agents write syntactically-valid, catastrophic SQL, and on a shared cluster the damage isn't theirs alone. A missing partition filter turns into a full scan that ties up every worker; an accidental cross join fills worker memory while everyone else's queries wait behind it; a retry loop runs it again. A SELECT * drags 40 columns into a context window that needed 2. The usual fix is to not give agents database access at all.

Lagaam gives them access with reins on:

  • Cost is a quotation, not a bill. Every query is priced from the engine's own plan before execution — EXPLAIN (TYPE IO) for the bytes it would scan, EXPLAIN (TYPE LOGICAL) for the widest row count any operator would build (the number a cross join blows and a LIMIT cannot hide). Over budget → blocked, with the number and the fix.
  • Un-estimable means no. No table statistics, a self-join that breaks the estimate, a passthrough the planner can't see — the gate fails safe instead of hoping.
  • Read-only, enforced in the AST. Single SELECT only. No DDL/DML, no multi-statement injection, no SELECT *, no table-function passthrough, and a LIMIT is injected when missing. Validated SQL is re-rendered, so what runs is exactly what was checked.
  • Agents ground themselves. list_catalogs and describe_table return exact names, types, and row estimates — scoped to the agent's table grant, so the agent never learns names it isn't allowed to touch.
  • Results are verified before they're trusted. Zero rows, truncated pages, all-NULL columns — the agent gets a warning with a next action, not a silently misleading answer.
  • Every call is audited. One JSONL line per tool call: who, what, allowed or denied, and why. A query's line puts the quote next to what the engine says it actually read, so you can see how far off the estimate was before you loosen or tighten a budget.

Doesn't Trino already limit this?

It limits a query once it is running. Lagaam refuses it before it starts. Keep both.

ActsWhat the agent seesCatches a cross join that reads little
query.max-scan-physical-bytesduring execution: terminated once the bytes are scanneda query failureno — it counts bytes read, not rows built
query.max-execution-timeduring execution: terminated after the time is spenta query failureonly after it has held the cluster that long
Resource groups (hardPhysicalDataScanLimit, softMemoryLimit, …)on the *next* query: new queries queue once the group is over its shareits later queries waitno — the running query continues
Lagaambefore execution, from EXPLAINa refusal with the number and the fixyes — it prices the rows the widest step would build

Measured on Trino 476: SELECT o.orderkey, l.partkey FROM tpch.tiny.orders o CROSS JOIN tpch.tiny.lineitem l LIMIT 10 reads 676,575 bytes by Trino's own plan — any scan cap above 0.7 MB lets it run — and would build 902,625,000 rows. Lagaam refuses it before it runs: *"This query would build 902,625,000 rows at its widest step, over your budget of 50,000,000 … a LIMIT will not help — join on a column with more distinct values, or filter each side before the join."*

Resource groups stay your backstop for everything that does reach the cluster; Lagaam is the gate in front of it for agent traffic.

What about other database MCP servers?

They're good servers that do a different job: keep the agent read-only and bound what comes back. Lagaam does that too, and also prices the query first.

Read-onlyRow capTimeoutChecks the plan before running
tuannvm/mcp-trinoon by defaultresults truncated while fetching (TRINO_MAX_ROWS)during execution (TRINO_QUERY_TIMEOUT)no — explain_query shows the agent a plan; it doesn't gate execute_query
startreedata/mcp-pinotalways on, parsed before executionLIMIT rewritten before execution, paged resultsduring execution (PINOT_QUERY_TIMEOUT, 60 s)no
bytebase/dbhubopt-in (readonly): keyword check plus the database's own read-only transactionopt-in (max_rows), injected as LIMIT/TOPopt-in (query_timeout), during executionno — opt-in explain_sql shows a plan; it doesn't gate execute_sql
Lagaamalways on, parsed before execution1,000 by default; a bigger LIMIT is lowered before it runsduring execution (LAGAAM_QUERY_TIMEOUT, 300 s)yes — scan bytes and widest-step rows from EXPLAIN; over budget is refused

Catch rate

11 queries an LLM agent plausibly writes — full scans, SELECT *, DDL, injection attempts, oversized joins, out-of-grant reads. A raw MCP wrapper submits all of them to the engine. Lagaam stops 11/11 before execution while the well-scoped control query runs untouched. Reproduce: benchmarks/catch_rate.py → results.

Quickstart

Against the Trino you already have (TRINO_PORT / TRINO_USER if yours aren't 8080 / lagaam):

TRINO_HOST=trino.internal LAGAAM_ALLOWED_TABLES=hive.sales.orders uvx lagaam   # MCP server on stdio

Or try it on a demo warehouse:

git clone https://github.com/lagaam-ai/lagaam && cd lagaam

docker compose -f examples/docker-compose.yml --profile trino up -d # demo warehouse cd server && uv sync LAGAAM_ALLOWED_TABLES=tpch.tiny.orders,tpch.tiny.lineitem \ uv run python -m lagaam # MCP server on stdio

For Pinot, --profile pinot brings up the batch quickstart and --profile pinot-realtime up -d brings up a Kafka-fed streaming one — run examples/pinot-realtime/bootstrap.sh after it to create the topics, tables and feed. Then start the server with LAGAAM_ENGINE=pinot.

Wire it into any MCP client (Claude Code, Claude Desktop, or your own agent):

{

"mcpServers": { "lagaam": { "command": "uvx", "args": ["lagaam"], "env": { "TRINO_HOST": "localhost", "LAGAAM_MAX_SCAN_BYTES": "5368709120", "LAGAAM_ALLOWED_TABLES": "hive.sales.orders,hive.sales.customers" } } } }

In Claude Code, install it as a plugin instead:

/plugin marketplace add lagaam-ai/lagaam

/plugin install lagaam@lagaam

It asks for the tables to allow (LAGAAM_ALLOWED_TABLES) and your Trino host, port and user (localhost / 8080 / lagaam if you leave them). From a shell, pass them as flags:

claude plugin marketplace add lagaam-ai/lagaam

claude plugin install lagaam@lagaam \ --config allowed_tables=hive.sales.orders --config trino_host=trino.internal

On Pinot, pick engine=pinot and set the controller and broker URLs (http://localhost:9000 / http://localhost:8000 if you leave them):

claude plugin install lagaam@lagaam --config engine=pinot \

--config allowed_tables=pinot.default.baseballStats \ --config pinot_controller_url=http://pinot.internal:9000 \ --config pinot_broker_url=http://pinot.internal:8099

Other LAGAAM_* settings, the Trino login (TRINO_PASSWORD or TRINO_JWT, plus TRINO_VERIFY for a private CA), and PINOT_USER / PINOT_PASSWORD for a Pinot with auth, are read from the environment you start claude in, so a password never sits in the plugin's config.

The agent gets three tools — list_catalogs, describe_table, query_data — and cannot reach the engine any other way.

Configuration

Env varMeaningDefault
LAGAAM_ALLOWED_TABLESComma list of catalog.schema.table grantsrequired
LAGAAM_ALLOW_ALL_TABLEStrue to run with no grant at alloff
LAGAAM_AGENT_NAMEIdentity stamped on the audit trailanonymous
LAGAAM_MAX_SCAN_BYTESScan-bytes budget per query, pre-execution50 GiB
LAGAAM_MAX_ROWSScanned-row estimate budget per queryungated
LAGAAM_MAX_INTERMEDIATE_ROWSRows the engine would *build* at its widest step — not rows returned, so a LIMIT doesn't lower it50,000,000
LAGAAM_MAX_RETURNED_ROWSRows returned to the agent per query — unset, the server applies its own 1000-row cap, and a bigger LIMIT in the query is lowered to it before it runs1000 (max 100000)
LAGAAM_QUERY_TIMEOUTWall-clock seconds per query300
LAGAAM_METADATA_TTLMetadata cache TTL, seconds300
LAGAAM_AUDIT_LOGAudit JSONL file pathstderr
LAGAAM_ENGINEpinot to run the native Pinot adaptertrino
PINOT_CONTROLLER_URL / PINOT_BROKER_URLPinot controller and brokerhttp://localhost:9000 / http://localhost:8000
PINOT_USER / PINOT_PASSWORDBasic-auth login for Pinotunset (no login)
TRINO_HOST / TRINO_PORT / TRINO_USERTrino coordinatorlocalhost / 8080 / lagaam
TRINO_PASSWORDPassword for TRINO_USER, for a cluster that wants a loginunset (no login)
TRINO_JWTJWT to log in with instead of a password — set one or the other, not bothunset
TRINO_HTTP_SCHEMEhttp or httpshttps once a password or JWT is set, else http
TRINO_VERIFYCheck the cluster's TLS cert: true, false, or the path of your CA bundle (PEM) for a private CAtrue

A shared Trino with a login works the same way. Set TRINO_PASSWORD (or TRINO_JWT) and lagaam talks https, since Trino won't take a password over plain http; set TRINO_PORT to the cluster's https port too (often 443 or 8443). A login the cluster refuses tells the agent so, without the password, and a password and a JWT both set stop the server at startup rather than guessing which one you meant. Try it locally against a Trino that wants both: examples/trino-auth/setup.sh, then docker compose -f examples/docker-compose.yml --profile trino-auth up -d.

The server will not start without `LAGAAM_ALLOWED_TABLES`. An agent that can reach every table in every catalog is the thing this exists to prevent, so that has to be asked for — set LAGAAM_ALLOW_ALL_TABLES=true if you mean it.

The budget dimensions above apply whether or not you set them. Leaving LAGAAM_MAX_SCAN_BYTES and LAGAAM_MAX_INTERMEDIATE_ROWS unset gives you their defaults, not an open gate — an unconfigured server refuses what it cannot afford rather than waving it through. If queries are being denied and you expected no limits, that is why; raise the dimension you mean to raise.

Cost quotes come from the engine's own plan estimates, and those need tab

Only the beginning is shown; read the rest in the repo