Skip to content
MCP server

FactQL

Ask questions of your databases and files and get SQL-verified answers or a decline

Pricing
Freemium
Platforms
API, CLI, Web
Runs
Locally or Remotely
Version
0.1.3
Listing updated
3 days ago

About FactQL

FactQL is a freemium MCP server for analytics and data. It can run locally on your machine or as a hosted remote server.

The idea behind FactQL is that a model writes a plausible query and the surrounding harness has to make it true. For each question it plans, explores the schema, drafts SQL, executes it to verify, self-corrects if needed and writes a summary limited to the result set. If it cannot verify an answer it fails closed and says so instead of guessing.

Every answer includes the SQL that ran, up to 50 rows and the lineage of tables and measures behind them. Sources named are Postgres, MySQL, a DuckDB gateway, uploaded CSV or XLSX files and PDFs with cited answers. Only SELECT queries run, under a statement timeout and only against tables an admin has enabled. The site suggests starting from an uploaded file rather than production credentials.

Through MCP, the ask tool returns one of three outcomes: an answer, a needs_clarification request, or a declined result with a reason. Each call is stateless, so follow-ups must restate what they refer to. Use the hosted server at https://api.factql.ai/mcp with a sign-in, or run uvx factql-mcp with an API key; an ask-only key is enough. The MCP package is MIT licensed.

Install

Run in a terminal

claude mcp add --transport http factql-mcp https://api.factql.ai/mcp

Add to Settings → Connectors → Add custom connector

https://api.factql.ai/mcp
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "factql-mcp": {
      "url": "https://api.factql.ai/mcp"
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

Add to .vscode/mcp.json

{
  "servers": {
    "factql-mcp": {
      "type": "http",
      "url": "https://api.factql.ai/mcp"
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "factql-mcp": {
      "serverUrl": "https://api.factql.ai/mcp"
    }
  }
}

Add to your client's MCP settings (most use this shape)

{
  "mcpServers": {
    "factql-mcp": {
      "type": "http",
      "url": "https://api.factql.ai/mcp"
    }
  }
}

Configuration

  • FACTQL_API_KEYFactQL API key (an ask-only key is enough)Required
  • FACTQL_BASE_URLFactQL API base URL
  • FACTQL_WORKSPACE_IDDefault workspace, for tenants that use workspaces
  • FACTQL_END_USER_IDWho is asking; defaults to mcp:<os user>

Tools this server provides (2)

Taken from the project documentation; the running server may differ.

whoami
Shows the tenant, plan and workspaces the key can query.
ask
Answers a question with the SQL that ran and up to 50 rows, or asks for clarification, or declines.

What it does

Execution-verified answers
Runs the query and checks the result before showing a number.
Decline instead of guess
Returns a declined result with a reason when it cannot verify.
SQL and rows included
Each answer ships its query, rows and lineage.
Multiple sources
Works with Postgres, MySQL, DuckDB, CSV, XLSX and PDFs.
Read-only queries
Only SELECT statements run, under a timeout.
Spend ceiling
The site says a budget alert is followed by a hard 402 rather than an invoice for overage.

Good for

  • Ask a business question of a warehouse from Claude or Cursor
  • Audit any answer by checking the SQL behind it
  • Analyse an uploaded spreadsheet without database credentials
  • Build an internal tool that must not show invented figures
  • Give each end user in an app private conversations

Pricing

Freemium

Free sign-up; paid plan prices not published

Prices change. Check factql.ai before you buy.

FactQL FAQ

What happens if it cannot verify an answer?

It returns a declined result with a reason instead of a guess.

Which queries can it run?

Only SELECT queries, against tables your admin has enabled.

Do I need an API key?

Yes for the local package; an ask-only key is enough. The hosted server uses a FactQL sign-in.

Is it stateful?

No. Each ask is stateless and the MCP client carries the conversation.

Is FactQL free?

FactQL has a free plan, with paid plans for more usage or features.

How do I add FactQL to Claude Code?

Run this command in your terminal: claude mcp add --transport http factql-mcp https://api.factql.ai/mcp

What are the best alternatives to FactQL?

The closest alternatives to FactQL are Agent-Native Analytics, Google Ads + Meta Ads + SEO/GEO MCP, Tapetide - Indian Stock Market MCP, Midplane and World Monitor.

Alternatives to FactQL

  1. Open-source analytics app where an AI agent builds charts and dashboards from your data

    • Remote
    • Open source
    • 7.7K GitHub stars
    • Analytics and data
  2. Hosted MCP connector for managing Google Ads, Meta Ads, GA4 and Search Console from chat

    • 8 tools
    • Remote
    • Freemium
    • 8.1K GitHub stars
    • Marketing and SEO
  3. Indian NSE and BSE stock market data for AI assistants through 48 MCP tools

    • 17 tools
    • Remote
    • Freemium
    • 150 GitHub stars
    • Finance and payments
  4. Midplane

    MCP server

    Postgres gateway for AI agents with table grants, column masking and approval for writes

    Runs locally
    • Open source
    • 5 GitHub stars
    • Databases
  5. World Monitor

    MCP server

    Live geopolitical intelligence dashboard with an API and MCP server for agents

    • Remote
    • Freemium
    • Analytics and data
  6. CompanyData

    MCP server

    Search and enrich company records from official registers via the CompanyData API

    • 3 tools
    • Remote
    • Paid
    • 3 GitHub stars
    • Analytics and data