Schemas

Expose a schema over MCP

The MCP Server tab shares a schema with AI assistants over MCP, the Model Context Protocol. An MCP-capable assistant, such as an AI coding tool, can then look up your tables, columns, views and relationships while it helps you.

In the app: Data Model › Schemas › your schema › MCP Server tab

It shares schema metadata only: names, columns, types, descriptions and relationships. It doesn’t connect to a database and never exposes data.

[screenshot]
The MCP Server tab: the Enable MCP Server switch, the server URL with its copy button, and the feature sub-tabs.

Before you start

The tab’s settings are only visible to people with Read/Write access to the schema.

Turn the server on

  1. Open the MCP Server tab. It is headed MCP Server Configuration.
  2. Under Server Settings, switch on Enable MCP Server.
  3. Copy the MCP Server URL with the button beside it, and add it to your MCP client.

Switch it off to stop serving the schema.

Choose what the server shares

Under Enable Features in MCP Server, each kind of object has a sub-tab and a switch:

  • Tables: Enable Tables in MCP
  • Views: Enable Views in MCP
  • Stored Procedures: Enable Stored Procedures in MCP
  • Functions: Enable Functions in MCP
  • Relationships: Enable Relationships in MCP shares the foreign keys between tables.

For tables, views, stored procedures and functions, once a kind is enabled you can share all of them (Allow All Tables, Allow All Views and so on) or turn that off and tick exactly which objects the assistant may see.

Tip: Start narrow. Enable only the object kinds an assistant needs, and leave sensitive tables or internal procedures off the list. You can widen access later.

Regenerate the URL

If the URL has been shared too widely, click Regenerate URL and confirm. Kenseme issues a new URL. Every client using the old one stops working until you give it the new URL. This can’t be undone.

See who has used it

Expand Recent activity to see recent calls to the schema’s MCP server: When, Tool, User, Detail, Outcome, Rows and Duration. Until someone connects, it says No activity yet.