> ## Documentation Index > Fetch the complete documentation index at: https://docs.xpander.ai/llms.txt > Use this file to discover all available pages before exploring further. # ClickHouse Query API > Connect ClickHouse Query API to xpander and give agents its 1 actions: how to create the API key and connect it, and which actions to hold for approval. HTTP API connector An HTTP API described by an OpenAPI spec, not an MCP server. Calls go to the server address you enter when connecting and carry HTTP basic authentication with the username and key you enter when connecting. ## What the skill can do API connector: 1 actions, as they appear in the skill panel. 1 of them create, change or delete something in ClickHouse Query API; mark those under **These actions need approval** when you add the skill to an agent. * **Query management** (1): Click House Endpoint Service Execute Sqlquery Httppost ## Connect ClickHouse Query API In Xpander Chat, open the agent's settings, click **Add skill**, and search for **ClickHouse Query API**. The connect dialog asks for a connection name and whether the connection is for the **Organization** (one shared account) or **Personal** (your own account, so the agent acts with your permissions where systems allow). On an agent other people use, a personal connection runs their requests as you unless the binding requires each person's own sign-in; see [whose credential a shared agent uses](/use/agents/permissions#whose-credential-a-shared-agent-uses). ClickHouse Query API connects with an API key. Create the key in ClickHouse Query API, paste it into the dialog, and click **Connect**. The key goes to the vault; the agent references it and never sees the value. Calls go to `{serverUrl}`. ## Give an agent the ClickHouse Query API skill Once ClickHouse Query API is connected, any agent you can edit may be given the skill: open the agent's settings, click **Add skill**, and choose **ClickHouse Query API**. Enable only the action groups the agent needs, and mark the actions that should wait for a named person's sign-off under **These actions need approval**. Which skills exist for your organization, and who may add them, is decided by your admins; see [Skills](/use/skills). ## Related Resources * [Skills](/use/skills) * [ClickHouse Query API API reference](https://clickhouse.com/docs/interfaces/http)