Socrata
Query, upsert, replace, delete, and poll rows in Socrata open-data portal datasets through SODA/SoQL.
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
How do I connect Socrata to my app?
Use Weavz Hosted Connect for Custom authentication. Install the SDK, create a connection through the connect portal or API, then execute tools programmatically.
What tools does Socrata support?
Socrata supports 5 tools including Query Rows, Get Record, Upsert Rows, Replace Record, Delete Record.
Can I use Socrata with AI agents?
Yes. Add Socrata to an MCP server in Tool Mode or Code Mode. Code Mode provides 3 meta-tools with on-demand API discovery so agents can compose stateful workflows without loading every action schema up front.
How do I connect Socrata to ChatGPT or Claude?
Open the Weavz connector setup, sign in, choose a workspace, and add Socrata as an approved app. ChatGPT, Claude, and other remote MCP clients can then call the scoped Socrata tools exposed by that workspace.
Does Socrata work with Claude Code, Cursor, Codex, and local agents?
Yes. Remote and local MCP clients can connect to a Weavz MCP endpoint for the workspace. Local coding agents can also use the Weavz CLI to inspect apps, discover actions, run approved Socrata work, and execute Code Mode workflows from a terminal.
What can I ask an AI agent to do with Socrata?
Socrata exposes 5 tools, including Query Rows, Get Record, Upsert Rows, Replace Record, Delete Record. Use Weavz to keep credentials scoped, require approval for sensitive work, and audit what the agent did.
Can Socrata be used in stateful agent workflows?
Yes. Agents can combine Socrata tools with Filesystem, State KV, Human Gates, input partials, and other workspace integrations while keeping execution scoped to the selected workspace or end user.
What authentication does Socrata use?
Socrata uses Custom. Weavz stores credentials securely and uses them for authorized action execution.
How much does the Socrata integration cost?
The Socrata integration is included on all Weavz plans including the free tier with 20,000 actions per month. No credit card required.
What triggers does Socrata support?
Socrata supports 1 triggers including Changed Rows.
Connect Socrata in minutes
Get 20,000 free action executions every month. No credit card required.