Ana as an MCP Server - TextQL Docs

Most AI assistants can answer questions about code, summarize documents, or help you draft an email. What they cannot do is connect to your data warehouse, reason over your actual data, and hand back a verified answer — from inside the tools you already use. Ana’s MCP server changes that. Any MCP-compatible client can now call Ana directly, get a warehouse-backed answer, and receive a link to the full TextQL thread — all without leaving the tool you’re already working in.

The Endpoint and Tool

MCP endpoint: https://app.textql.com/mcp Ana exposes a single tool: ask_question. Pass it any natural language question. Ana connects to your warehouse through your configured connectors and Ontology, runs the analysis, and returns the answer alongside a link back to the full chat thread in TextQL. Charts, dashboards, and reports come back as resource links directly in your client. This is the same Ana that runs in TextQL — with access to your connected warehouses and your Ontology, consumable headlessly from any MCP-compatible surface.

Ana answering a data question inside Claude

Setup

Go to Claude.ai → Settings → Integrations
Click Add MCP Server
Enter https://app.textql.com/mcp as the server URL
Name it ana and save

Adding Ana as an MCP server in Claude Web settings

Authorization happens automatically the first time you invoke ask_question.

Add Ana to your Cursor MCP configuration. Open (or create) ~/.cursor/mcp.json:

{
  "mcpServers": {
    "ana": {
      "url": "https://app.textql.com/mcp"
    }
  }
}

Restart Cursor. On your first ask_question call, Cursor will open a browser window for OAuth authorization.

Open Windsurf Settings → MCP Servers and add a new server:

{
  "mcpServers": {
    "ana": {
      "url": "https://app.textql.com/mcp"
    }
  }
}

Save and reload. The first use triggers a one-time OAuth flow in your browser.

Add Ana as an MCP server in Claude Code settings:

{
  "mcpServers": {
    "ana": {
      "url": "https://app.textql.com/mcp"
    }
  }
}

Or run from the CLI:

claude mcp add --transport http ana https://app.textql.com/mcp

The first time you use Ana in a session, you’ll be prompted to authorize via OAuth.

Go to ChatGPT → Settings → Connectors
Click Add connector
Enter https://app.textql.com/mcp as the MCP endpoint
Follow the OAuth prompt to authorize

Once connected, you can ask Ana data questions directly in any ChatGPT conversation.

Open Copilot Settings → Extensions → MCP
Click Add MCP server
Enter https://app.textql.com/mcp
Complete the one-time OAuth authorization

Ana will appear as an available tool in your Copilot sessions.

First-Time Authorization

The first time your client calls Ana, you’ll be redirected to the TextQL UI to complete a one-time OAuth authorization. This connects your TextQL identity to your MCP client — Ana knows which connectors and Ontology to use for your queries.

TextQL OAuth authorization screen in Claude

After authorization, your client connects headlessly. You won’t need to re-authorize unless you revoke access.

What Ana Returns

When you call ask_question, Ana returns:

The answer — a plain-language response grounded in your actual warehouse data
A thread link — a URL to the full chat thread in TextQL, where you can explore further, share results, or dig into the SQL
Resource links — charts, dashboards, and reports are returned as links directly in your client

Managing Access

As a user: View and revoke authorized MCP clients from Settings → Authorized Applications. Each authorized client is listed with the scopes it holds. Revoking an application requires re-authorization the next time that client tries to connect. As an admin: Manage all registered MCP clients across your organization from Settings → MCP Connectors. You can see which clients are authorized, what scopes they hold, and revoke any client from the organization.

Documentation Index

​The Endpoint and Tool

​Setup

​First-Time Authorization

​What Ana Returns

​Managing Access

​Further Reading

The Endpoint and Tool

Setup

First-Time Authorization

What Ana Returns

Managing Access

Further Reading