Peliqan MCP Server

Contents

• Contents
• What is the Peliqan MCP Server?
• Prerequisites
• Setup
• Setup in ChatGPT
• Setup in Claude
• Setup in Claude in an Organization account
• Setup in Claude Code (terminal)
• Setup in Microsoft Copilot
• Setup in Copilot in Visual Studio (VS Code)
• Setup in other MCP Clients
• Verifying the connection
• What the Peliqan MCP Server can do
• Debug connections & pipelines
• Explore your data
• Manage query tables
• Build & run Data Apps
• Manage API endpoints
• Sub-account management (partner accounts only)
• Resources the AI can read
• Example prompts to get started
• Build a custom MCP Server
• Need help?

What is the Peliqan MCP Server?

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:

‣

Setup in ChatGPT

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:

Leave the authentication setting to oAuth. Login with your Peliqan user account to authenticate.

‣

Setup in Claude

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:

Next, login with your Peliqan user account to authenticate.

‣

Setup in Claude in an Organization account

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:

Instruct 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 mcp add --transport http peliqan https://mcp.eu.peliqan.io/mcp

{
  "mcpServers": {
    "peliqan": {
      "type": "http",
      "url": "https://mcp.eu.peliqan.io/mcp"
    }
  }
}

‣

Setup in Microsoft Copilot

Steps to add an MCP Server in Copilot:

• Open Copilot Studio: https://copilotstudio.microsoft.com
• Create an Agent
• In the agent, add a Tool > MCP Server

Enter 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

Click on “Not connected” to add a connection:

Login 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 Studio

If you don’t have permissions to publish you agent, follow the below steps to allow a user to publish an agent:

‣

Click to expand

Add a security group (to which the user belongs) in Power Automate Admin center, for the setting Manage > Tenant settings > “Copilot studio authors”.

If you get an error “A custom connector with display name xxx already exists”, follow the below steps:

‣

Click to expand

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.

{
  "servers": {
    "peliqan": {
      "type": "http",
      "url": "https://mcp.eu.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

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:

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.