Socrata Open Data MCP connector
The Socrata Open Data connector lets Claude, ChatGPT, Cursor, Microsoft Copilot and the Elaichi Agent search Socrata Open Data datasets and read their records, with every lookup running as the person who asked and written to an audit log.
- Connects with an API key
- Free 14-day trial
- No credit card
Which Socrata Open Data datasets cover building permits?
Working in Socrata Open Data with Elaichi
-
List all Socrata Open Data records
-
List all Socrata Open Data datasets
-
Get single Socrata Open Data dataset by ID
How to connect Socrata Open Data to Claude, ChatGPT, Cursor or Microsoft Copilot
Step by step, for each AI app
Socrata Open Data MCP connector for Claude
-
1
Open Customize, then Connectors.
-
2
Press Add.
-
3
Name it, paste the MCP server URL, then Continue.
https://api.elaichi.ai/mcp -
4
Sign in and approve.
On Team and Enterprise, an Owner adds it once. Everyone else turns it on for themselves.
Socrata Open Data MCP connector for Claude Code
-
1
In a terminal, run
claude mcp addwith the endpoint.https://api.elaichi.ai/mcp -
2
Start Claude Code and run
/mcp. -
3
Pick elaichi, then sign in and approve in the browser.
Terminal
$ claude mcp add --transport http elaichi --scope user https://api.elaichi.ai/mcp
Use --scope project instead to share it with the repository through .mcp.json.
Socrata Open Data MCP connector for ChatGPT
-
1
Open Plugins, then press the + button.
-
2
Name it and paste the endpoint into Server URL.
https://api.elaichi.ai/mcp -
3
Leave Authentication on OAuth, then tick the risk acknowledgement.
-
4
Press Create, then sign in and approve.
Works on the web. The plugin directory lives at chatgpt.com/plugins.
Socrata Open Data MCP connector for Cursor
-
1
Open
~/.cursor/mcp.json. -
2
Add the endpoint under
mcpServers.https://api.elaichi.ai/mcp -
3
Reload Cursor, then sign in and approve.
~/.cursor/mcp.json
{
"mcpServers": {
"elaichi": {
"url": "https://api.elaichi.ai/mcp"
}
}
}
Set up per machine, so repeat it on each computer you work from.
Socrata Open Data MCP connector for Microsoft Copilot
-
1
In Copilot Studio, open your agent, then Tools, Add a tool, New tool and Model Context Protocol.
-
2
Paste the endpoint into Server URL, choose OAuth 2.0, then Dynamic discovery, and press Create.
https://api.elaichi.ai/mcp -
3
Create a new connection, sign in and approve, then press Add to agent.
-
4
Under Channels, open Teams and Microsoft Copilot and make the agent available in Microsoft Copilot.
- Server URL
- https://api.elaichi.ai/mcp
- Authentication
- OAuth 2.0
- Type
- Dynamic discovery
Microsoft Copilot was called Microsoft 365 Copilot. Keep the tool on end-user credentials, so each person signs in as themselves.
Connect Socrata Open Data to any MCP client
-
1
Add the endpoint as a remote MCP server.
https://api.elaichi.ai/mcp -
2
Sign in and approve.
{
"mcpServers": {
"elaichi": {
"url": "https://api.elaichi.ai/mcp"
}
}
}
The Elaichi Agent already has these tools, with nothing to set up.
What teams do with Socrata Open Data through Elaichi
Ask in plain English. Each person’s AI can do only what they’re allowed to, and every action it takes in Socrata Open Data is logged.
-
Policy
Pull the numbers for a briefing
Ask for the latest records in a Socrata Open Data dataset such as service requests or permits and get the figures you need for a council briefing without opening the portal.
-
Research
Find which datasets cover a topic
Ask which Socrata Open Data datasets exist for housing, transit or public health and get a list with what each one holds before you start an analysis.
-
Communications
Check a figure before it goes out
Before a press release or social post, confirm a number against the published Socrata Open Data records so the statement matches what the public can see.
-
Planning
Compare records across neighborhoods
Read building permit or inspection records from Socrata Open Data and have the agent group them by district or month for a planning review.
-
Finance
Read published budget line items
Open a Socrata Open Data budget dataset by its ID and ask for the line items behind a department total when a question comes in.
-
Operations
Watch a dataset for new records
Ask what has been added to a Socrata Open Data dataset since last week, such as new service requests or closures, and summarize it for the team.
Try asking
- “Which Socrata Open Data datasets cover building permits?”
- “Show the latest 311 service request records for this week's briefing.”
- “Open the budget dataset and list line items for Public Works.”
What connecting Socrata Open Data gets you
6 screens from Elaichi, each doing one job for your Socrata Open Data account.
Ask Elaichi to work across your apps.
Which Socrata Open Data datasets cover building permits?
Show the latest 311 service request records for this week's briefing.
Open the budget dataset and list line items for Public Works.
Also runs in Claude, ChatGPT, Cursor or Microsoft Copilot
The agent
Ask about any dataset in plain language.
Get answers from live Socrata Open Data records, not a stale export.
Copy the endpoint
AI apps
One endpoint for every client you use.
Reach Socrata Open Data from Claude, ChatGPT or Cursor with no SDK and no shared key.
Tool catalog
3 Socrata Open Data tools, no code needed.
List datasets, open one by ID and read its records without writing a line.
Toolboxes
Give each team its own toolbox.
Policy, Research and Planning each get a Socrata Open Data toolbox scoped to them.
Shared connections
Share a connection without sharing the key.
Teammates read Socrata Open Data datasets through one connection and never see the API key.
Audit log
Answer who read what, every time.
Every Socrata Open Data lookup is logged with who, when, type and dataset.
From answering questions to doing the work
A trigger starts the work, inside the same permissions and the same audit log as everything else. Workflows, collections and live dashboards come with the Black plan.
Socrata Open Data digest
Run 418 · started 2 minutes ago · on behalf of Emily Carter
-
✓
Schedule
Every weekday at 8:00 AM
0.2s -
✓
Fetch datasets
Socrata Open Data
1.4s -
✓
Group by owner
Transform
0.1s -
✓
Draft the digest
Agent step
Ran with 4 tools, returned a structured summary
6.2s -
Approve the digest
Needs approval
Assigned to Jake Morgan
Approve Deny -
Post the digest
Socrata Open Data
Queued
Workflows
A schedule starts the work, not a prompt.
New Socrata Open Data records are fetched, grouped, drafted into a digest and approved by a person.
Socrata Open Data health
Refreshed 4 minutes ago · every 15 minutes · from the datasets collection
Datasets
1,284 ↓ 12%
Records
96 ↓ 8%
Needs attention
3 ↑ 2
Updated this week
412 ↑ 9%
Datasets created
Last 14 days
By team
Share of activity
Policy 34%
Research 27%
Communications 21%
Planning 18%
Collections and dashboards
Dataset health, refreshed on a schedule.
Records created over 14 days and a breakdown by team, computed without a model.
For IT and engineering
Elaichi vs Zapier MCP vs Composio for Socrata Open Data
All three can connect Socrata Open Data to an AI assistant, and all three have admin controls. They differ in where access lives and how you pay.
| What to check | Elaichi | Zapier MCP | Composio |
|---|---|---|---|
| Where the AI connects |
One address for the whole organization.
https://api.elaichi.ai/mcp
|
A server per member, created at sign-in. | An MCP endpoint per team, or an SDK. |
| Control over Socrata Open Data tools | Allow or restrict single Socrata Open Data tools, per role or user. | App and action restrictions on the account. | Role permissions, down to the action. |
| Record of calls | One audit entry per Socrata Open Data call. | A History tab of tool calls. | A log of every tool call. |
| Single sign-on | SAML or OIDC, plus SCIM, on Gold. | SAML on Enterprise. | SAML and OIDC on Enterprise. |
| Price | Free for one person; $15 per user per month on Gold. | 2 tasks per successful call. | Billed per tool call. |
Sources: Zapier MCP docs, security, usage; Composio docs, gateway, enterprise, pricing. Checked September 2026.
Longer take: Zapier MCP alternative and when you don't need an MCP gateway.
Socrata Open Data tools for your AI agents
3 tools are ready to call through Elaichi's MCP endpoint the moment you connect Socrata Open Data, governed by the same roles, restrictions, and audit log as everything else in Elaichi.
No tools match your search.
Questions, answered
How do I connect Socrata Open Data to Claude?
In Elaichi, add the Socrata Open Data connector and paste in the API key from your Socrata account, there is no OAuth application to register and no client ID or secret to generate. Then in Claude open Customize, then Connectors, then Add, and paste https://api.elaichi.ai/mcp. Sign in to Elaichi when Claude asks and Socrata Open Data datasets are available in your next conversation.
Does Socrata Open Data work with ChatGPT and Cursor as well as Claude?
Yes. Once Socrata Open Data is connected in Elaichi, the same endpoint, https://api.elaichi.ai/mcp, works in Claude, ChatGPT, Cursor, Microsoft Copilot, any MCP client and the Elaichi Agent. You connect Socrata Open Data once and every client sees the same datasets under the same rules.
What can an AI agent actually do with my Socrata Open Data data?
An agent can list the datasets available on your Socrata Open Data portal, open a specific dataset by its ID to see what it contains, and read the records inside it. In practice that means asking for the latest permit records, finding which datasets cover transit, or pulling budget line items for a question. Short, concrete asks such as naming the dataset and the month tend to work better than long sentences.
Does connecting Socrata Open Data give the AI every dataset on the portal?
It gives the AI exactly what the API key used to connect Socrata Open Data can already see, and nothing more. Elaichi can narrow that further by role or by person so a team only reaches certain datasets, but it can never widen access beyond what Socrata Open Data itself allows.
Can I stop an agent from deleting or changing things in Socrata Open Data?
The Socrata Open Data connector only lists datasets and reads records, so nothing can be deleted or changed through it. Even so, each action can be restricted for a role or for one person in Elaichi, for example to keep a group from opening certain datasets. A restricted action still appears in Elaichi's tool search, flagged as restricted, but no client can run it, whatever the prompt says.
What happens to a Socrata Open Data connection when someone leaves?
When a person is offboarded in Elaichi, their access to Socrata Open Data through Elaichi ends at once, in every client. A shared Socrata Open Data connection keeps working for everyone else on the team. If you ever want to remove Socrata Open Data entirely, disconnecting it once in Elaichi removes it from Claude, ChatGPT, Cursor, Microsoft Copilot and every other client at the same time.
Does the Socrata Open Data MCP connector work with Gemini, Codex, Claude Code or other MCP clients?
Yes. Socrata Open Data is reached over the same MCP endpoint every client uses, so anything that speaks MCP can call it — Gemini, Codex, Claude Code, Windsurf, Cline, Zed and OpenCode among them — alongside Claude, ChatGPT, Cursor, Microsoft Copilot, and the Elaichi Agent. The tools on offer and the access behind them are identical whichever client asks. Only the setup screen differs.
Is Elaichi an alternative to Zapier MCP for Socrata Open Data?
Yes. Both let Claude, ChatGPT or Cursor use Socrata Open Data. Zapier MCP fits a team that already automates in Zapier, since each person signs in and acts as themselves in that account. Elaichi fits when IT wants one address for the whole company, per-tool rules by role, and a record of every Socrata Open Data call.
How is Elaichi different from Composio for Socrata Open Data?
Composio gives AI agents tools and sign-in handling across 1,000+ apps, for developers building agents or people using an assistant, billed per tool call. Elaichi gives a company's own people governed access to Socrata Open Data: one address, restrictions per role or user, and $15 per user per month. Both have role permissions and a log of every call.
Put Socrata Open Data in front of your team
14 days of Black, no credit card. Connect it once and pick what each team can call.
When the trial ends, nothing is deleted. You move to the free Personal plan, and connections, roles and the audit log stay where they are.
Add one link to your AI app
The same link for everyone on your team.
https://api.elaichi.ai/mcp
ChatGPT
Claude
Cursor
Microsoft Copilot