MCP App Store
by KeenEthics
TextQL icon

TextQL MCP Server for ChatGPT

By TextQL

Overview

Connect ChatGPT to all your data, from cloud warehouses and on-prem databases to business applications and BI platforms. Analyze across all of them at petabyte scale, with answers grounded in TextQL's ontology and access governed by your existing permissions.

How to connect

  1. ChatGPT: Open the TextQL listing in the ChatGPT app directory and choose Connect. ChatGPT listing TextQL exposes 36 tools here.

Tools

get_profile

ChatGPT
Return the TextQL user represented by this request's authenticated credentials. The opaque id is unique within this app and remains unchanged across token refresh, reconnection, and name or email changes.

refinery_connector_api_get

ChatGPT
Read one API connector's metadata, by id or name, without its secrets. Read-only.

refinery_connector_api_list

ChatGPT
List the API connectors this organization has configured, without their secrets. Read-only.

refinery_connector_cancel

ChatGPT
Stop a refinery_connector_* call that is still running, by its operation_id.

refinery_connector_db_list

ChatGPT
List the database and BI connectors this organization has configured. Read-only.

refinery_connector_db_preview

ChatGPT
Print the first rows of a table without loading it into a sandbox. Read-only.

refinery_connector_db_tables

ChatGPT
List tables in a database connector, optionally filtered by schema or name. Read-only.

refinery_connector_wait

ChatGPT
Wait for a refinery_connector_* call that returned while still running, by its operation_id, and return its result. Call it with the same org until the result arrives. Read-only.

refinery_ontology_diff

ChatGPT
Show the library/ changes a sandbox would propose, without authoring a patch.

refinery_ontology_propose

ChatGPT
Author or revise an Ontology patch from a sandbox's library/ changes, under your Ontology permissions.

refinery_org_clear

ChatGPT
Clear the default organization, so calls that omit org run in the organization the connection was approved in. The choice is saved for this connection until changed.

refinery_org_set

ChatGPT
Set the organization calls run in when they omit org. After setting one, remember its id and still pass it as org on every later call. The choice is saved for this connection until changed.

refinery_query

ChatGPT
Run SQL or governed TQL against one database/BI connector; the result lands as a dataframe in a remote sandbox. Queries may modify warehouse data if the connected system and the user's permissions allow it. Pass sandbox_id to keep results together.

refinery_query_cancel

ChatGPT
Stop a refinery_query call that is still running, by its operation_id.

refinery_query_wait

ChatGPT
Wait for a refinery_query call that returned while still running, by its operation_id, and return its result. Call it with the same org until the result arrives.

refinery_sandbox_bash

ChatGPT
Run a bash command in a fresh sandbox process (requires the organization's bash tool). Code can modify sandbox files and reach external systems.

refinery_sandbox_cancel

ChatGPT
Stop a refinery_sandbox_* call that is still running, by its operation_id.

refinery_sandbox_list

ChatGPT
List the sandboxes the server reports for you.

refinery_sandbox_new

ChatGPT
Create a remote analysis sandbox.

refinery_sandbox_python

ChatGPT
Run Python in a sandbox's persistent kernel; variables and dataframes carry across calls until the sandbox restarts. Code can modify sandbox files and reach external systems.

refinery_sandbox_rm

ChatGPT
Stop a sandbox. The server also reaps idle sandboxes after about an hour. Stopping destroys the sandbox's running state, including loaded dataframes.

refinery_sandbox_status

ChatGPT
Show a sandbox's status, memory and loaded dataframes.

refinery_sandbox_wait

ChatGPT
Wait for a refinery_sandbox_* call that returned while still running, by its operation_id, and return its result. Call it with the same org until the result arrives.

refinery_workspace_agent_list

ChatGPT
List the agents you can see, active and inactive, with links. Read-only.

refinery_workspace_agent_show

ChatGPT
Show one agent's full configuration, by id or name. Read-only.

refinery_workspace_app_list

ChatGPT
List the apps you can see, with links. Read-only.

refinery_workspace_app_show

ChatGPT
Show one app's full definition, by id or name. Read-only.

refinery_workspace_artifact_list

ChatGPT
List the artifacts you can see, with links. Read-only.

refinery_workspace_artifact_show

ChatGPT
Show one artifact's full content, by id or name. Read-only.

refinery_workspace_chat_list

ChatGPT
List your chats, newest first, with links. Read-only.

refinery_workspace_chat_show

ChatGPT
Show one chat, by id or name, with its message history. Read-only.

refinery_workspace_context

ChatGPT
Read the organization's standing context: the auto-attached Ontology files that apply to your role and connectors. Read-only.

refinery_workspace_dashboard_list

ChatGPT
List the dashboards you can see, with links. Read-only.

refinery_workspace_dashboard_show

ChatGPT
Show one dashboard's full definition, by id or name. Read-only.

refinery_workspace_info

ChatGPT
Show the workspace, your identity, roles, scopes, tool availability and sandboxes. Read-only.

refinery_workspace_orgs

ChatGPT
List the organizations you belong to, marking the one calls run in by default. Pass an id or name from it as org on any tool. Read-only.

Capabilities

Writes

Example Prompts

Click any prompt to copy it.

Similar Apps

Listed on MCP App Store

Listed on MCP App Store

Add this badge to your site or README. It links to this page.

HTML

<a href="https://mcp-app-store.keenethics-labs.com/app/textql"><img src="https://mcp-app-store.keenethics-labs.com/badges/listed-on-mcp-app-store.svg" alt="Listed on MCP App Store" width="220" height="44"></a>

Markdown

[![Listed on MCP App Store](https://mcp-app-store.keenethics-labs.com/badges/listed-on-mcp-app-store.svg)](https://mcp-app-store.keenethics-labs.com/app/textql)