You can build your Remote MCP Server directly on the Peliqan Data Cloud and use it to e.g. query data in your data warehouse.

Set up your MCP Server In Peliqan

You can use the Peliqan MCP Server template out of the box. This MCP Server currently has following capabilities (implemented as “tools” in the MCP Server):

• List connections
• List tables
• List columns in a table
• Execute an SQL query

Note that you can extend this MCP Server by adding your own “tools”, these are Python functions decorated with @mcp.tool().

1. Install the “MCP Server” script from the app templates:

2. Add an API endpoint (method POST) and link it to the “MCP Server” script (this is the API handler script). Click here for more info on how to publish an API endpoint in Peliqan.

3. Update the credentials (API key) in your script and store in the Peliqan Secret Store.

Configure your MCP Client

ChatGPT

In ChatGPT, click on your account name (bottom left corner) and click on Settings.

Go to Settings > Apps > Advanced Settings > Enable “Developer mode”.

Go to Settings > Apps > Create App.

Enter the URL of your MCP API endpoint, including the API key:

If you make updates to your MCP Server (e.g. you add tools), make sure to click the “Refresh” button on the detail screen of your app and check if the new actions are available for your app.

Claude

You can use Claude.ai (in the browser) or Claude Desktop, but you need a Paid plan (e.g. Claude Pro) to add a Remote MCP Server.

Go to Settings > Connectors > Add custom connector.

Enter the URL of your MCP API endpoint, including the API key: