Socrata MCP integration
Query, upsert, replace, delete, and poll rows in Socrata open-data portal datasets through SODA/SoQL.
Sign in, add Socrata in Apps, then choose the account your AI can use.
Tools
| Name | Description |
|---|---|
query_rowsQuery a Socrata dataset with SODA/SoQL select, where, order, limit, offset, and full-text parameters. | Query a Socrata dataset with SODA/SoQL select, where, order, limit, offset, and full-text parameters. |
get_recordGet one Socrata row by row identifier. | Get one Socrata row by row identifier. |
upsert_rowsCreate or update rows in a Socrata dataset by posting an array of row objects. | Create or update rows in a Socrata dataset by posting an array of row objects. |
replace_recordReplace one Socrata row by row identifier. | Replace one Socrata row by row identifier. |
delete_recordDelete one Socrata row by row identifier. | Delete one Socrata row by row identifier. |
Triggers
| Name | Description |
|---|---|
changed_rowsPoll a Socrata dataset for rows whose :updated_at system field is newer than the last poll. | Poll a Socrata dataset for rows whose :updated_at system field is newer than the last poll. |
Quick Start
import { WeavzClient } from '@weavz-io/sdk'
const weavz = new WeavzClient({ apiKey: 'wvz_...' })
const result = await weavz.actions.execute('socrata', 'query_rows', {
workspaceId: '550e8400-e29b-41d4-a716-446655440000',
integrationAlias: 'socrata',
input: { /* ... */ },
})Related Integrations
Works well with
Frequently Asked Questions
Is there a Socrata MCP server through Weavz?
Yes. Add the Socrata integration to a Weavz workspace, enable the actions you need and connect any required account. Weavz provides the workspace MCP endpoint in Tool Mode or Code Mode. The catalog currently lists 5 Socrata actions.
What can an AI agent do with Socrata?
Available actions include Query Rows, Get Record, Upsert Rows, Replace Record, Delete Record. Your workspace exposes only the actions you enable. The agent also needs the intended account access and any required input values.
How do I connect Socrata to Claude or ChatGPT?
Use a compatible remote MCP client, add the Weavz connector and choose a workspace. Add Socrata, connect the required account and review the enabled actions. Client availability and account requirements vary; adding the connector does not authorize every app automatically.
Can I use Socrata through an API or SDK?
Yes, supported actions can run through the Weavz REST API, TypeScript SDK or Python SDK. Configure a workspace and the required connections, use scoped access, and pass the intended end-user context when acting for a customer.
What authentication does Socrata require?
The catalog lists custom credentials for Socrata. Use Hosted Connect to authorize the intended account. Required permissions, provider app access and available connection methods depend on the integration.
How do I review sensitive Socrata actions?
Limit enabled actions, scope credentials to the intended user and configure Human Gates for the operations that need review. A matching policy can pause a send, record change or other sensitive action for an approver before execution.
What limits or costs apply to Socrata?
Weavz plan limits apply to the actions and resources you use. The external provider may also require an account, a paid plan, API credits or specific permissions, and may enforce its own rate limits. Check current Weavz pricing and the provider’s terms before rollout.
What Socrata triggers are available?
The catalog lists 1 triggers, including Changed Rows. Configure the trigger and your event handler before using incoming events to start work.
Connect Socrata in minutes
Get 20,000 free action executions every month. No credit card required.