Skip to main content
The Peliqan MCP (Model Context Protocol) Server lets AI assistants and other clients like Claude.ai, Claude Code, Claude Desktop, Gemini, Microsoft Copilot and ChatGPT talk directly to your Peliqan account. Once connected, the AI can explore your data, debug pipelines, write and run data apps, manage query tables, and call API endpoints, all without leaving your chat. Think of it as giving Claude (or any other MCP Client) a direct line into Peliqan and into your data.

Prerequisites

  • A Peliqan account
  • An account on for example Claude.ai or ChatGPT, or Claude Code or Claude Desktop installed (or any other MCP Client)

Setup

Use one of the following MCP URLs:
In ChatGPT click on your user name (bottom left corner), in the menu go to Settings > Plugins> Browse plugins > Click ”+” (plus) icon in the right top corner, and enter the Peliqan MCP URL:ChatGPT plugin setup showing MCP URL inputLeave the authentication setting to oAuth. Login with your Peliqan user account to authenticate.
In Claude Desktop or in Claude.ai in your browser, click on Customize in the top left corner > Connectors > Click on the plus icon > Select “Add custom connector” and enter the URL of the Peliqan MCP Server:Claude add custom connector screenNext, login with your Peliqan user account to authenticate.
In Claude Desktop or in Claude.ai in your browser, click on your username (bottom left corner), select Organization Settings from the menu > Connectors > Add > Custom > Web, and enter the URL of the Peliqan MCP Server:Claude organization settings for MCP connectorInstruct your team members to add a connection using their personal Peliqan account as follows: click on your username (bottom left corner), select Settings from the menu > Connectors > find the Peliqan MCP connection and click on the Connect button:Claude team member connect button
Run this command:
Or add the following to your ~/.claude.json file. If the file doesn’t exist yet, create it.
After saving, restart Claude Code. You should see Peliqan listed when you type /mcp in the chat.
Steps to add an MCP Server in Copilot:Copilot Studio add MCP Server toolEnter following details for the MCP Server:
  • Server name: Peliqan
  • Server description: Peliqan MCP Server to access Peliqan data
  • Server URL: https://mcp.eu.peliqan.io/mcp (example for the EU instance of Peliqan)
  • Authentication: oAuth 2.0
  • Type: Dynamic discovery
Copilot Studio MCP Server configuration formClick on “Not connected” to add a connection:Copilot Studio connection status showing Not connectedLogin into Peliqan to authorize access (oAuth flow). A new connection will be added.Publish your agent in Copilot Studio to make it available in Copilot chat. Next, you can access your Agent in Copilot chat and use it to access the Peliqan MCP Server.Troubleshooting in Copilot StudioIf you don’t have permissions to publish you agent, follow the below steps to allow a user to publish an agent:Add a security group (to which the user belongs) in Power Automate Admin center, for the setting Manage > Tenant settings > “Copilot studio authors”.Power Automate Admin center tenant settingsPower Automate Admin center security group selectionIf you get an error “A custom connector with display name xxx already exists”, follow the below steps:Go to Power Automate > More > Discover all > Custom connectors. This will show a list of all “Tools” of type MCP Server that were added to your Copilot agents in the past. Delete old connectors here.
Open mcp.json (or create this file) in the .vscode folder under your Project root in VS Code and add this MCP configuration:
Check your client’s documentation on how to add an MCP Server. You can use any MCP-compatible AI client that supports HTTPS transport, and connect using the Peliqan MCP Server URL:
  • EU customers: use https://mcp.eu.peliqan.io/mcp
  • US customers: use https://mcp.us.peliqan.io/mcp

Verifying the connection

Once connected, try these prompts to confirm everything is working:
  • “List my Peliqan connections”
  • “Show me all databases in my Peliqan account”
  • “List my data apps”
If you see results from your Peliqan account, you’re all set.

What the Peliqan MCP Server can do

Debug connections & pipelines

  • See all your data source connections and their sync status
  • View recent pipeline run history
  • Read raw error logs when a sync fails

Explore your data

  • Browse all databases, schemas, and tables
  • Inspect column names and types
  • Preview rows of data

Manage query tables

  • View run history and error logs for a failing query table
  • Check upstream/downstream dependencies before making changes
  • Create, update, and delete SQL query tables
  • Test fixes in an isolated schema before applying to production

Build & run Data Apps

  • Write Python scripts and run them as background jobs (shell mode)
  • Create interactive Streamlit web UIs and publish them with a shareable URL
  • Build HTTP API handlers and expose them as REST endpoints
  • Schedule scripts to run automatically
  • Get and set the state of Data Apps (e.g. get configuration of an app, stored in the state)

Manage API endpoints

  • Create, update, and delete HTTP endpoints backed by your Python scripts
  • View recent call logs for any endpoint

Sub-account management (partner accounts only)

  • List all customer sub-accounts
  • Run any tool against a specific sub-account by passing sub_account_id

Resources the AI can read

These resources are automatically available to the AI — no extra setup needed.

Example prompts to get started

“My Salesforce connection hasn’t synced since yesterday. Can you check what’s wrong and show me the error logs?”
The AI will list connections, find the failing run, and read the logs for you.
“Show me what tables exist in the ‘analytics’ schema and preview the first 10 rows of the orders table.”
The AI will browse schemas and return a data preview.
“Write a Python script that reads from our Stripe connection, calculates monthly revenue, and prints the results. Run it now.”
The AI will write the script, create a data app, and run it in shell mode — returning the output in the chat.
“Query table ‘monthly_summary’ is failing. Can you diagnose the issue and fix it?”
The AI will read the run logs, identify the error, test a fix in a temp schema, and apply it to production.

Build a custom MCP Server

Peliqan also allows you to implement your own custom MCP Server, for internal use and/or for your customers and partners. More information: Build a custom MCP Server on Peliqan

Need help?

Reach out to Peliqan support: support@peliqan.io. You can also ask your AI (e.g. Claude) directly. Once the Peliqan MCP Server is connected, the AI has full context on how Peliqan works.