Labsco
cloud9charts logo

Knowi

from cloud9charts

Query databases, build dashboards, and analyze documents in natural language from Claude or any MCP client. 28+ tools, 70+ data sources.

πŸ”₯πŸ”₯πŸ”₯πŸ”₯βœ“ VerifiedFreeQuick setup

Knowi MCP Server

Connect Claude Code, Claude Desktop, Cursor, or any MCP-compatible AI client to Knowi. Query your data, create dashboards, manage reports, and more β€” in natural language, directly from your AI assistant.

The MCP server is built into the Knowi application. No separate installation required.

Available Tools

AI-Powered Tools

Natural language tools that use Knowi's AI orchestrator to interpret instructions and chain operations.

ToolDescription
knowi_doExecute any Knowi operation via natural language
knowi_askAsk a data question β€” finds the dataset, generates a query, returns results
knowi_searchSearch across all dashboards, widgets, datasets, and reports

Deterministic Tools

Direct, fast operations with predictable behavior.

ToolDescription
knowi_list_dashboardsList all accessible dashboards
knowi_get_dataRetrieve data rows from a widget or dataset
knowi_push_dataPush data rows to a dataset (creates it if it doesn't exist)
knowi_get_detailsGet full metadata for any asset
knowi_find_widgetFind widgets by name
knowi_create_datasourceCreate a new datasource connection
knowi_create_queryCreate and run a query against a datasource
knowi_create_widgetCreate a new chart or visualization
knowi_update_widgetUpdate an existing widget
knowi_create_reportCreate a scheduled report
knowi_create_alertCreate a data alert
knowi_list_alertsList configured alerts
knowi_test_alertTest an alert
knowi_update_alertUpdate an alert
knowi_runTrigger execution of a query or report
knowi_export_pdfExport a dashboard or widget as PDF
knowi_export_csvExport data as CSV
knowi_get_embed_urlGenerate an embeddable share URL
knowi_get_insightsGet AI-generated insights for a widget
knowi_layout_dashboardArrange widgets on a dashboard
knowi_import_fileImport a file (CSV, Excel) as a dataset
knowi_ingest_documentIngest a document for AI Q&A
knowi_ask_documentAsk questions against ingested documents
knowi_extract_document_dataExtract structured data from a document
knowi_list_documentsList ingested documents
knowi_delete_documentDelete an ingested document
knowi_deleteDelete an asset (requires explicit confirmation)

Token Management

Rotate a token:

  1. Go to Settings β†’ AI Settings β†’ MCP Token
  2. Click Revoke Token
  3. Generate a new one and update your config:
claude mcp remove knowi
claude mcp add knowi https://your-instance.knowi.com/api/2.0/mcp \
  --transport http \
  --header "Authorization: Bearer YOUR_NEW_TOKEN"

One token per user. Generating a new token automatically revokes the previous one.


API Reference

The MCP server exposes both Streamable HTTP (for MCP clients) and REST endpoints (for direct programmatic use).

Health Check

curl https://your-instance.knowi.com/api/2.0/mcp/health
{
  "status": "healthy",
  "toolCount": 28,
  "tools": ["knowi_do", "knowi_ask", "knowi_search", "..."],
  "activeSessions": 0
}

List Tools

curl -H "Authorization: Bearer YOUR_TOKEN" \
  https://your-instance.knowi.com/api/2.0/mcp/tools

Call a Tool (REST)

curl -X POST https://your-instance.knowi.com/api/2.0/mcp/tools/call \
  -H "Authorization: Bearer YOUR_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{
    "name": "knowi_list_dashboards",
    "arguments": {}
  }'

Streamable HTTP (JSON-RPC)

All MCP client operations use POST /api/2.0/mcp with standard JSON-RPC:

# Initialize
curl -X POST https://your-instance.knowi.com/api/2.0/mcp \
  -H "Authorization: Bearer YOUR_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{"jsonrpc":"2.0","id":1,"method":"initialize","params":{}}'

The response includes an Mcp-Session-Id header to use on subsequent requests.


Security

  • Scoped credentials: MCP tokens only access MCP endpoints β€” they cannot be used against the broader Management API.
  • Authorization on every request: Every tool verifies the authenticated user has access to the requested resource before executing.
  • Prompt injection protection: AI-powered tools scan instructions for known injection patterns and reject them before reaching the AI model.
  • Destructive operation safeguard: knowi_do blocks delete/drop/purge instructions. Deletions require the explicit knowi_delete tool with a required confirm: true parameter.
  • Data truncation: knowi_get_data and knowi_ask return at most 100 rows by default.
  • Session security: Streamable HTTP sessions are bound to the authenticated user. Session IDs alone do not grant access.

Data Flow

When Claude calls a Knowi MCP tool, the tool response (data rows, metadata, insights) is returned to Claude and processed on Anthropic's infrastructure. This is inherent to MCP β€” the client must receive results to act on them.

For maximum data isolation, use Knowi's in-product AI agents instead of MCP.


Documentation


Support