Getting Started
Getting Started
Once connected, you can ask Claude or ChatGPT things like "What were our top locations by revenue last month?" or "Build me a dashboard comparing provider performance across locations" — and it will pull directly from your CorralData account to answer.
Choose Your Setup
Connecting to Claude
You'll add CorralData directly inside Claude.ai or the Claude Desktop app.
You'll need admin access to your Claude.ai organization to complete this setup.
Open your Claude.ai Organization Settings
Log in to claude.ai, click your organization name in the upper left, and select Settings.
Go to Connectors
In the left sidebar, click Connectors. Scroll down and click Add Custom Connector. Or, click here to go there directly.
Fill in the connection details
Enter the following values exactly as shown:
Name
CorralData
URL
https://mcp.corraldata.com/mcp
OAuth Client ID
corral-mcp-client
OAuth Client Secret
iAu9n27mfuS8RrMv7iVCVqp801Hi6xqi
Why is the client secret visible here? These credentials identify the CorralData app to Claude — they don't grant access to your data on their own. Your CorralData login is what actually controls access. Think of it like a public app ID, not a password.
Click Add
CorralData will now appear in your connectors list.
You're done! CorralData will be available in new Claude conversations. Claude will have access to all accounts your login can view. If your login has access to more than one account, confirm with Claude which one you're working in before running queries or creating widgets.
Add the CorralData skill (recommended)
The connector gives Claude access to your data. The CorralData skill teaches Claude how to use it well: how to explore your schemas, write correct SQL, and read your boards and widgets. Installing it leads to faster, more accurate answers with less back-and-forth. It is optional, and only available on Claude clients that support skills.
To install it: download the file below, then in Claude go to Settings, then Capabilities, then Skills, and choose Upload skill. Select the downloaded file. Claude applies it automatically whenever a conversation involves your CorralData data.
Your first conversation
After connecting, try asking Claude:
"What databases and schemas are available in my CorralData account?"
Claude will use the list_schemas tool to discover your data. From there you can explore further:
"Show me the tables in the public schema"
"Describe the customers table — what columns does it have?"
"Write a SQL query to find the top 10 customers by revenue this month"
Understanding permissions
What you can do depends on your role in CorralData:
All authenticated users
Explore schemas, tables, and relationships. Execute read-only SQL queries. View boards, widgets, filters, and datasets.
board.edit role
All of the above, plus create and update boards and board filters.
widget.edit role
All of the above, plus create and update widgets and datasets.
If you try an action you don't have permission for, Claude will let you know. Contact your CorralData administrator to request additional roles.
Tips for effective use
Start with schema exploration — Ask Claude to list schemas and describe tables before writing queries. This helps it understand your data model and write accurate SQL.
Use progressive disclosure — Ask for a list of boards first, then drill into a specific one. This keeps responses concise.
Be specific with SQL — When asking for data, mention the table names and columns you're interested in.
Leverage filters — When listing boards or widgets, mention the name or keyword you're looking for to narrow results.
Connecting to ChatGPT
You'll add CorralData directly inside the ChatGPT web app.
You'll need a paid ChatGPT subscription (Plus, Pro, or Team) to use custom MCP connectors.
Enable Developer Mode
Log in to ChatGPT, click your profile name in the left sidebar, and select Settings. Navigate to Connectors, then Advanced Settings, and toggle on Developer mode.
Fill in the connection details
Enter the following values exactly as shown:
Name
CorralData
MCP Server URL
https://mcp.corraldata.com/mcp
Authentication
OAuth
OAuth Client ID
corral-mcp-client
OAuth Client Secret
iAu9n27mfuS8RrMv7iVCVqp801Hi6xqi
Why is the client secret visible here? These credentials identify the CorralData app to ChatGPT — they don't grant access to your data on their own. Your CorralData login is what actually controls access. Think of it like a public app ID, not a password.
Enable CorralData in chat
Open a new chat. Click the + icon in the message bar, then More → Developer Mode → Add Sources, and toggle on CorralData.
You'll need to do this step each time you start a new chat where you want to use CorralData.
You're done! CorralData will be available once enabled in a chat. Remember to turn it on at the start of each new conversation (Step 5 above). ChatGPT will have access to all accounts your login can view. If your login has access to more than one account, confirm with ChatGPT which one you're working in before running queries or creating widgets.
Your first conversation
After connecting, try asking ChatGPT:
"What databases and schemas are available in my CorralData account?"
ChatGPT will use the list_schemas tool to discover your data. From there you can explore further:
"Show me the tables in the public schema"
"Describe the customers table — what columns does it have?"
"Write a SQL query to find the top 10 customers by revenue this month"
Understanding permissions
What you can do depends on your role in CorralData:
All authenticated users
Explore schemas, tables, and relationships. Execute read-only SQL queries. View boards, widgets, filters, and datasets.
board.edit role
All of the above, plus create and update boards and board filters.
widget.edit role
All of the above, plus create and update widgets and datasets.
If you try an action you don't have permission for, ChatGPT will let you know. Contact your CorralData administrator to request additional roles.
Tips for effective use
Start with schema exploration — Ask ChatGPT to list schemas and describe tables before writing queries. This helps it understand your data model and write accurate SQL.
Use progressive disclosure — Ask for a list of boards first, then drill into a specific one. This keeps responses concise.
Be specific with SQL — When asking for data, mention the table names and columns you're interested in.
Leverage filters — When listing boards or widgets, mention the name or keyword you're looking for to narrow results.
Last updated
Was this helpful?