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/mcpAdd to Settings → Connectors → Add custom connector
https://api.factql.ai/mcpAdd to ~/.cursor/mcp.json
{
"mcpServers": {
"factql-mcp": {
"url": "https://api.factql.ai/mcp"
}
}
}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)RequiredFACTQL_BASE_URLFactQL API base URLFACTQL_WORKSPACE_IDDefault workspace, for tenants that use workspacesFACTQL_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

Agent-Native Analytics
MCP serverOpen-source analytics app where an AI agent builds charts and dashboards from your data
- Remote
- Open source
- 7.7K GitHub stars
- Analytics and data

Google Ads + Meta Ads + SEO/GEO MCP
MCP serverHosted 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

Tapetide - Indian Stock Market MCP
MCP serverIndian NSE and BSE stock market data for AI assistants through 48 MCP tools
- 17 tools
- Remote
- Freemium
- 150 GitHub stars
- Finance and payments

Midplane
MCP serverPostgres gateway for AI agents with table grants, column masking and approval for writes
Runs locally- Open source
- 5 GitHub stars
- Databases

World Monitor
MCP serverLive geopolitical intelligence dashboard with an API and MCP server for agents
- Remote
- Freemium
- Analytics and data

CompanyData
MCP serverSearch and enrich company records from official registers via the CompanyData API
- 3 tools
- Remote
- Paid
- 3 GitHub stars
- Analytics and data