MCP server · Analytics

Lagaam MCP server

Let your AI query Trino or Pinot safely, with every query checked and priced before it runs.

Lagaam is a helper that sits between your AI assistant and your data warehouse, so your AI can look things up without accidentally slowing down everyone else's queries. It is handy for anyone who wants to ask questions about data in Trino or Apache Pinot but worries about a runaway query. You set a budget, and Lagaam refuses anything too expensive before it starts.

What is an MCP server? The 30-second version

On its own, your AI can only chat with you. An MCP server is a small helper program that gives your AI a new skill or a connection to an app or service. Here, Lagaam connects your AI to Trino or Apache Pinot, which are systems that store and query large amounts of data. Once connected, your AI can ask those systems questions for you, and Lagaam makes sure the questions are safe and affordable.

What this MCP server does

You ask your AI a question about your data, like how many orders were placed last month. Your AI turns that into a database query and hands it to Lagaam. Lagaam checks the query against your rules, estimates how much work it would take, and if it is too big it refuses and explains why. If it is fine, Lagaam runs it and gives the results back to your AI, which then answers you. Every step is written to an audit log so you can see what happened.

What you can do with it

Ask questions about your Trino or Pinot data in plain English
See what tables and columns are available before you query
Get a warning if a query would be too expensive or unsafe
Receive a clear reason and a suggested fix when a query is refused
Limit how many rows come back so your chat stays readable
Keep a record of every query your AI tried to run

Try asking your AI

“How many orders were placed last month?”
“Show me the top 10 customers by total sales.”
“What columns are in the sales.orders table?”
“List all the tables I am allowed to query.”

What it gives back to you

You get the answer in your chat, usually as a short table or a number. If a query is refused, you get a message explaining why and what to change. If results look odd, like all empty or cut off, Lagaam warns you so you do not trust a misleading answer. Everything is also logged for later review.

Before you start

What you need

A Trino or Apache Pinot database you can connect to
The host, port, and username for that database
A list of tables you want to allow (required)
Python and uv installed if you run it yourself

Good to know

It can only read data, never change or delete it, but it will refuse queries if your tables lack statistics, so run ANALYZE first.

Install it with your AI

Add Lagaam MCP server to your AI, no technical skills needed

You don't install anything by hand. You copy one prompt, paste it into an AI that can work on your computer, and it checks, installs and connects the server for you, asking you when it needs something.

Sign in to get the install prompt

Members get a ready-made prompt that lets the Claude desktop app check Lagaam MCP server, install it and connect it for them, step by step. You don't need any technical skills: you copy, paste and answer a few questions. Your connected AI can also find and install any of the 4,611 MCP servers here for you.