Build on it · 18
Your AI assistant reads the model
MCP is the standard AI tools now use to reach outside systems, and we serve it. One line of setup in Claude, Cursor or anything else that speaks it, and their own assistant can read their model and ask questions of their database, read-only.
Connecting it, once
- Someone adds GramSpec to their assistant. One address. They can give it a key made on their account page, or simply sign in when asked.
- The assistant's first call is told where to sign in. With no key, the answer names the sign-in address, and the assistant registers itself and opens it in the browser.
- The person signs in to GramSpec and approves. Through the ordinary sign-in, a second factor included where they have one. The assistant never sees their password.
- The assistant is given a token. Good for an hour and renewed by itself for up to ninety days. Tokens and keys are random, and only their hashes are kept. Each call after that is checked against them.
A question
- Someone asks their assistant a business question. In the tool they already work in. The language model doing the reasoning is theirs.
- The assistant calls GramSpec. Each call carries the key or token, and a call from a web page on some other site is refused.
- It works through eight tools, all read-only. List the models on the account, load one or get an overview of it, search it, read one thing in full, have SQL written, check SQL, and run it. The model itself can also be attached to the conversation.
- SQL is checked against the model before it runs. The same checks Reason's own queries pass: a plain read, nothing from the database's system tables, and tables and joins that are the ones the model declares. The assistant can ask for the check alone.
- It runs on their database, read-only, and the rows go back to the assistant. When the model has no path for a question, what goes back is a refusal that names what is missing, not a guess.