Skip to content

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
Claude Elaichi connected

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
Ask anything…
Governance / Audit log Last 24 hours
Socrata Open Data Get single Socrata Open Data dataset by ID Emily Carter · Claude · 9:41 AM Done
Socrata Open Data List all Socrata Open Data datasets Emily Carter · Claude · 9:41 AM Done
Socrata Open Data List all Socrata Open Data records Emily Carter · Claude · 9:41 AM Done
Socrata Open Data List all Socrata Open Data records Megan Brooks · ChatGPT · 9:38 AM Done
Socrata Open Data List all Socrata Open Data records Ryan Hayes · Cursor · 9:35 AM Done

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. 1

    Open Customize, then Connectors.

  2. 2

    Press Add.

  3. 3

    Name it, paste the MCP server URL, then Continue.

    https://api.elaichi.ai/mcp
  4. 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. 1

    In a terminal, run claude mcp add with the endpoint.

    https://api.elaichi.ai/mcp
  2. 2

    Start Claude Code and run /mcp.

  3. 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. 1

    Open Plugins, then press the + button.

  2. 2

    Name it and paste the endpoint into Server URL.

    https://api.elaichi.ai/mcp
  3. 3

    Leave Authentication on OAuth, then tick the risk acknowledgement.

  4. 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. 1

    Open ~/.cursor/mcp.json.

  2. 2

    Add the endpoint under mcpServers.

    https://api.elaichi.ai/mcp
  3. 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. 1

    In Copilot Studio, open your agent, then Tools, Add a tool, New tool and Model Context Protocol.

  2. 2

    Paste the endpoint into Server URL, choose OAuth 2.0, then Dynamic discovery, and press Create.

    https://api.elaichi.ai/mcp
  3. 3

    Create a new connection, sign in and approve, then press Add to agent.

  4. 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. 1

    Add the endpoint as a remote MCP server.

    https://api.elaichi.ai/mcp
  2. 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.”

See all 3 Socrata Open Data tools →

What connecting Socrata Open Data gets you

6 screens from Elaichi, each doing one job for your Socrata Open Data account.

Elaichi Agent

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.

ElaichiAI apps
Claude ChatGPT Cursor Microsoft Copilot

Copy the endpoint

https://api.elaichi.ai/mcp
Client Connected by Status Last used
Claude
E

Emily Carter

• Connected 4 minutes ago
Cursor
M

Megan Brooks

• Connected 2 hours ago
ChatGPT
R

Ryan Hayes

• Connected Yesterday

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.

ElaichiTools
Tool Action Description
List all Socrata Open Data records List List rows of one Socrata dataset by dataset_id. Pass a small limit (10-50; the default is 1000 rows) and select only the columns you need. where, select, q and order map to SoQL, e.g. where=county='Monroe'. Other parameters are exact-match column filters. For counts, pass select=count(*) and order=count(*).
List all Socrata Open Data datasets List Search the datasets published on the connected portal (Socrata Discovery API). Use q to search by name or topic and a small limit (10 to 25). Each item's resource.id is the dataset_id for the records tool, and resource.columns_field_name lists its column names.
Get single Socrata Open Data dataset by ID Get Get one dataset's metadata by its 4x4 id (e.g. vn5v-hh5r): name, description, when its rows were last updated, and its columns. Use columns[].fieldName as the names in the records tool's select, where and order.

Tool catalog

3 Socrata Open Data tools, no code needed.

List datasets, open one by ID and read its records without writing a line.

ElaichiToolboxes
Name Source template Tools Created

Policy toolbox

Socrata Open Data · briefing figures and service datasets

Socrata Open Data starter 18 Mar 4, 2026

Research toolbox

Socrata Open Data · dataset discovery and records

— 9 Mar 2, 2026

Communications toolbox

Socrata Open Data · published figures for releases

— 24 Feb 27, 2026

Planning toolbox

Socrata Open Data · permit and inspection records

Socrata Open Data starter 6 Feb 19, 2026

Finance toolbox

Socrata Open Data · budget datasets and line items

— 31 Jan 30, 2026

Operations toolbox

Socrata Open Data · new records and dataset changes

— 12 Jan 22, 2026

Toolboxes

Give each team its own toolbox.

Policy, Research and Planning each get a Socrata Open Data toolbox scoped to them.

ElaichiConnections
Connection Scope Status Access
SO

Socrata Open Data (Policy)

Connected by Emily Carter

Personal • Active 1 team · 6 members
SO

Socrata Open Data (Research)

Connected by Jake Morgan

Organization • Active 3 teams · 24 members
SO

Socrata Open Data (Communications)

Connected by Megan Brooks

Organization • Active 2 teams · 11 members
SO

Socrata Open Data (Planning)

Connected by Tyler Reed

Personal • Needs re-auth 1 team · 3 members
SO

Socrata Open Data (Finance)

Connected by Ryan Hayes

Personal • Active Not shared
SO

Socrata Open Data (Operations)

Connected by Ashley Parker

Personal • Active 2 teams · 9 members

Shared connections

Share a connection without sharing the key.

Teammates read Socrata Open Data datasets through one connection and never see the API key.

ElaichiAudit log
When Who What happened Type

2 minutes ago

Mar 6, 2026, 3:10 PM

E

Emily Carter

[email protected]

Restriction Created Access

8 minutes ago

Mar 6, 2026, 3:04 PM

J

Jake Morgan

[email protected]

Restriction Updated Access

14 minutes ago

Mar 6, 2026, 2:58 PM

M

Megan Brooks

[email protected]

Role Assigned Access

20 minutes ago

Mar 6, 2026, 2:52 PM

T

Tyler Reed

[email protected]

Socrata Open Data Users Updated MCP

26 minutes ago

Mar 6, 2026, 2:46 PM

R

Ryan Hayes

[email protected]

Socrata Open Data Datasets Created MCP

32 minutes ago

Mar 6, 2026, 2:40 PM

A

Ashley Parker

[email protected]

Socrata Open Data Datasets List Toolbox

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

  1. ✓

    Schedule

    Every weekday at 8:00 AM

    0.2s
  2. ✓

    Fetch datasets

    Socrata Open Data

    1.4s
  3. ✓

    Group by owner

    Transform

    0.1s
  4. ✓

    Draft the digest

    Agent step

    Ran with 4 tools, returned a structured summary

    6.2s
  5. Approve the digest

    Needs approval

    Assigned to Jake Morgan

    Approve
  6. 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

Live

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.

Elaichi compared with Zapier MCP and Composio for Socrata Open Data, by what to check
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.

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 my team share one Socrata Open Data connection?

Yes. One person connects Socrata Open Data in Elaichi and shares the connection with a team, and nobody else ever handles the API key. Each teammate still signs in to Elaichi as themselves, so the audit log names the person who read each dataset, not the account that was connected.

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