Accessing Ragic Data via MCP

You can authorize a third-party AI tool to read data in your own Ragic account using MCP (Model Context Protocol). Once connected, you can ask the AI to search for data, summarize content, cross-reference records, or answer questions about your data.

Note: Ragic MCP currently only supports reading data. The AI can query data you have access to, but can't create, edit, or delete it.

Use Cases

Once connected, AI can help you:

1. Look up the database accounts, sheets, and fields you have access to.

2. Search for data by keyword, without needing to know which sheet it's in.

3. Browse a sheet's Listing Page, or read a full record, including Subtables, comments, field notes, and email threads.

4. Filter data by creator, entry manager or creation date.

MCP Access Scope

Ragic MCP reads data according to the access rights you already have in Ragic:

1. It only reads and returns the database accounts, sheets, and fields you have access to.

2. If you're an External User in a database account, MCP won't read any data from it.

3. Ragic's internal system configuration sheets aren't accessible via MCP.

Connecting to Ragic MCP

Before You Start

1. Identify your database account: You'll need to know which Ragic database account you want to query. You can find this from the URL. For example, if your Ragic homepage URL is:

https://www.ragic.com/mycompany

then "mycompany" is your database account name. Once connected, you can simply tell the AI: "In the mycompany account, help me find...". If you're not sure of your database account name, you can ask the AI to "list the Ragic database accounts I have access to".

2. Get the connection URL: If you're using cloud service, use:

https://www.ragic.com/api/mcp

If you're using an On-premises Plan, please check with your administrator for the correct URL, which is usually:

https://your-server-address/api/mcp

Connecting in claude.ai

In claude.ai, you can add Ragic MCP through a custom connector.

Steps:

1. Open the "Customize" settings page in claude.ai.

2. Add a "custom connector".

3. Enter "Ragic" as the name.

4. Enter the connection URL: https://www.ragic.com/api/mcp

Note: If you're using an On-premises Plan, use the URL your administrator provides instead.

5. Choose OAuth as the authentication method, or follow the default settings shown on screen.

6. Save, then follow the prompts to log in to Ragic and complete authorization.

7. Go back to the conversation and enable the Ragic connector — you're ready to start asking about your data.

Connecting in ChatGPT

In chatgpt.com, you can create a Ragic app through Developer mode. If you don't see the relevant settings for your account or organization, please check your plan or contact your organization admin.

Steps:

1. Open ChatGPT settings.

2. Go to the app's advanced settings and turn on "Developer mode".

3. Go back to the app settings and click "Create app".

4. Enter "Ragic" as the name.

5. Enter the connection URL: https://www.ragic.com/api/mcp

Note: If you're using an On-premises Plan, replace the connection URL with the one your administrator provides.

6. Choose OAuth as the authentication method.

7. After saving, follow the prompts to log in to Ragic and complete authorization.

8. Select this Ragic app in a chat, and you can then ask ChatGPT to read your Ragic data.

Note: The entry point for ChatGPT's developer mode and available plans may change depending on OpenAI's interface. If you don't see the option for developer mode or creating an app, please check your account plan and organization settings.

Advanced Setup: Claude Code / Codex

If you use developer tools like Claude Code or Codex, you can also connect to Ragic MCP. This section is for users comfortable with the command line or config files.

Cloud Service

If you're using cloud service, you can add the remote MCP server directly from your terminal.

Claude Code:

claude mcp add --transport http --scope user ragic https://www.ragic.com/api/mcp

Once added, type the following in the Claude Code interactive window:

/mcp

Follow the prompts to complete Ragic login and authorization.

Codex: This writes to your user-level ~/.codex/config.toml:

codex mcp add ragic --url https://www.ragic.com/api/mcp

Then follow Codex's login flow to complete authorization.

On-premises Plan

If you're using an On-premises Plan without a trusted CA certificate, or your environment only supports MCP connections through local commands, you'll need to connect using mcp-remote instead — and you'll need to install Node.js, npm, and npx first.

If npm or npx isn't installed on your computer, download and install the LTS version from the Node.js official website first; npm will be installed along with Node.js. Once installed, reopen your terminal and run the following commands to verify:

node -v
npm -v
npx -v

Once all three commands show a version number, you can use the setup below. When you run npx -y mcp-remote, the system will automatically fetch mcp-remote the first time — no separate installation needed.

Claude Code: In your project's .mcp.json, you can switch to using mcp-remote instead:

claude mcp add ragic --scope user -e NODE_TLS_REJECT_UNAUTHORIZED=0 -- npx -y mcp-remote https://localhost/api/mcp --allow-http

Replace https://localhost/api/mcp with your actual Ragic MCP connection URL.

Codex: You can switch to mcp-remote like this:

codex mcp add ragic --env NODE_TLS_REJECT_UNAUTHORIZED=0 -- npx -y mcp-remote https://localhost/api/mcp --allow-http

Replace https://localhost/api/mcp with your actual Ragic MCP connection URL.

Note: mcp-remote doesn't have a logout function. If you need to switch accounts or log in again, manually delete the local authentication data first, then restart Claude Code or Codex — you'll be redirected to the Ragic login flow.

Mac:

rm -rf ~/.mcp-auth

Windows:

1. PowerShell:

Remove-Item "$HOME\.mcp-auth" -Recurse -Force

2. cmd:

rmdir /s /q "%USERPROFILE%\.mcp-auth"

On-Premises Connection Setup

If you're on an On-premises Plan, check the following with your administrator first:

• Whether Ragic MCP is enabled. See here for how to enable it.
• The correct connection URL.
• Whether that URL is reachable by the AI service you're using.
• Whether the HTTPS certificate is valid.

If you're using a web-based AI like claude.ai or chatgpt.com, the connection to your Ragic MCP URL is made by the cloud service, not directly by your browser. So you don't need to configure allowed browser origins separately. Cloud service requires no extra setup; the On-premises Plan just needs the URL to be reachable from outside services.

Example Prompts

You can use Ragic MCP just like you'd ask any other question. Here are some common examples.

1. Check available database accounts

• "List the Ragic database accounts I can access."
• "Which Ragic accounts can I look up?"

2. View sheets

• "What sheets are there in mycompany?"
• "What fields are in the Customer sheet in mycompany?"

3. Search for data

• "Search mycompany for 'annual contract'."
• "Find records that mention 'return.'"
• "I'm not sure which sheet has it. Find anything related to Taipei logistics."

4. Read and organize records

• "List the first 20 records in the Customer sheet in mycompany."
• "Summarize the full details of the orders you just found."
• "Compare the three customer records you found."

5. Query by person or date

• "List the orders created by jane@example.com."
• "Find the customers managed by John Smith."
• "List the records created in January 2026."

Note: If you only remember someone's name and aren't sure of their email, you can first ask the AI to find the matching person, then use that email to search further.

FAQ

1. How do I log in the first time I connect?

The first time you connect, the AI service will walk you through the Ragic login flow. Log in with your own Ragic account; if your company supports Google login, you can use that too. Once you're logged in, the AI can read data according to your access rights.

2. Can the AI modify my data?

No. Ragic MCP currently only supports reading data. The AI can query data you have access to, but it can't create, edit, or delete anything. If other types of functionality become available in the future, we'll provide separate details on authorization and usage limits.

3. What if I can't find my data?

Check the following:

• Whether the database account name is correct.
• Whether you already have access to that sheet or record in Ragic.
• Whether your search keyword is too specific.
• Whether your date or person filters are too strict.

If you're not sure which sheet the data is in, try asking the AI to search by keyword first.

4. Why are some fields missing?

MCP reads data according to your access rights in Ragic. If you don't have access to a field in Ragic, the AI won't see it either.

5. What if a web-based AI can't connect to my on-premises server?

Contact your administrator to check the following:

• Whether the connection URL is correct.
• Whether the on-premises server is reachable from outside services.
• Whether the HTTPS certificate is valid.