Overview

This guide walks you through connecting the inmydata MCP (Model Context Protocol) server to ChatGPT, enabling ChatGPT to query and analyse your inmydata datasets through natural language conversations.

The MCP protocol allows AI assistants like ChatGPT to securely connect to external data sources. Once configured, you can ask ChatGPT questions about your data and receive instant insights without leaving your conversation.

Prerequisites

  • An active inmydata account with administrator access
  • A ChatGPT Plus or Team subscription (required for custom MCP apps)
  • Access to configure MCP clients in your inmydata tenant

Part 1: Create an MCP Client in inmydata

First, you need to create MCP client credentials in your inmydata tenant that ChatGPT will use to authenticate.

  1. Sign in to your inmydata platform at [tenant].inmydata.com using your credentials.
  2. Navigate to the AI settings. From the main interface, access the settings menu and select the AI section from the left sidebar.
  3. Locate the MCP Clients section. This section displays any existing MCP clients and allows you to create new ones.
  4. Click the "+ Add client" button in the top right corner of the MCP Clients panel.
  5. Configure the new client:

Name

Enter a descriptive name (e.g., "ChatGPT")

Client Type

Select "ChatGPT" from the dropdown

 

  1. Click OK to create the client.
  2. Save your credentials immediately. A dialog will appear showing your Client ID and Client Secret.

⚠ Important: Copy both the Client ID and Client Secret now. The Client Secret will not be shown again. If you lose these credentials, you will need to create a new client.

 

  1. Click "Copy client ID" and paste it somewhere safe. Repeat for "Copy client secret".
  2. Click OK to close the credentials dialog. Your new ChatGPT client will now appear in the MCP Clients list.

Part 2: Configure the App in ChatGPT

Now configure ChatGPT to connect to your inmydata tenant using the credentials you just created.

  1. Open ChatGPT at chatgpt.com in your web browser and sign in to your account.
  2. Access Settings. Click your profile icon in the bottom left corner and select Settings.
  3. Navigate to Apps. In the settings sidebar, click Apps.
  4. Enable Developer mode. Click on Advanced and toggle on Developer mode. This allows you to add custom MCP connectors.

ℹ Note: Developer mode disables ChatGPT memory for conversations that use custom MCP apps. This is a security feature to protect your data.

 

  1. Add a new app. Return to the Apps section and click Add App or look for an option to add a custom connector.
  2. Enter the app details:

Name

inmydata (or your preferred name)

MCP Server URL

https://mcp.inmydata.com/mcp

Authentication

Select "OAuth" from the dropdown

OAuth Client ID

Paste your Client ID from Part 1

OAuth Client Secret

Paste your Client Secret from Part 1

 

  1. Accept the risk acknowledgement. Check the box labelled "I understand and want to continue". This acknowledges that custom MCP servers are not reviewed by OpenAI.
  2. Click "Create" to add the app.
  3. Complete the OAuth flow. You may be redirected to inmydata to authorise the connection. Follow any prompts to complete the authentication.
  4. Verify the connection. A green banner will appear saying "inmydata is now connected". Your app will now show in the Apps section with a "Disconnect" option, indicating it is successfully connected.

Using the inmydata Connection

Once connected, you can query your inmydata datasets directly in ChatGPT conversations. When using custom MCP apps, ChatGPT operates in "Developer mode" where memory is disabled for security.

Simply start a new chat and ask questions about your data. ChatGPT will use the MCP connection to retrieve and analyse your information.

Example Queries

  • "List the tables available from the inmydata MCP connection"
  • "What are the top 10 suppliers by spend?"
  • "Show me purchase order trends for the last 12 months"
  • "What value of purchase orders were placed this quarter?"

ChatGPT will automatically use the available MCP tools (such as get_rows_fast, get_top_n_fast, and get_answer_slow) to retrieve and present your data along with helpful analysis.

Security Considerations

  • Keep your credentials secure. Never share your Client ID and Client Secret publicly or commit them to version control.
  • Developer mode protects your data. ChatGPT disables memory when using custom MCP apps to prevent unintended data retention.
  • Data access follows your inmydata permissions. ChatGPT can only access the data your user account has permission to view in inmydata.
  • Revoke access if needed. You can delete the MCP client in inmydata or disconnect the app in ChatGPT settings at any time to immediately revoke access.

Troubleshooting

  • Can't add custom app: Ensure Developer mode is enabled in Settings > Apps > Advanced.
  • Connection fails: Verify that both the Client ID and Client Secret are copied correctly with no extra spaces.
  • OAuth redirect fails: Ensure you are signed into your inmydata account in the same browser and have the necessary permissions.
  • Lost credentials: Delete the existing client in inmydata and create a new one.
  • No data returned: Ensure your inmydata user account has the necessary permissions to access the requested data subjects.
  • App shows disconnected: Return to Settings > Apps and reconnect the inmydata app.

Need help? Contact inmydata support at support@inmydata.com