Connecticut Open Data

live Government

Connecticut Open Data — US government open data (data.ct.gov) via the Socrata SoQL API: state agencies, public health, education & transportation. Keyless.

3 tools
0ms auth
free tier 50 calls/day

Tools

datasets

Search the Connecticut Open Data catalog of open datasets by keyword. Returns each dataset's resource_id, name, description, category and update date — pass the resource_id to query/metadata.

No parameters required.

▶ Try it
query

Run a Socrata SoQL query against a Connecticut Open Data dataset by resource_id (e.g. "28fr-iqnx"). Filter with where/select/group/order (SoQL clauses, without the leading $) plus limit/offset. Return

No parameters required.

▶ Try it
metadata

Get a Connecticut Open Data dataset's schema + metadata (columns, types, row count, category, last-updated) by resource_id, e.g. "28fr-iqnx".

No parameters required.

▶ Try it

Test with curl

The gateway speaks JSON-RPC 2.0 over HTTP POST. You can test any pack directly from the terminal.

List available tools
bash 
curl -X POST https://gateway.pipeworx.io/data-connecticut/mcp \
  -H "Content-Type: application/json" \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/list"}'
Call a tool
bash 
curl -X POST https://gateway.pipeworx.io/data-connecticut/mcp \
  -H "Content-Type: application/json" \
  -d '{"jsonrpc":"2.0","id":2,"method":"tools/call","params":{"name":"datasets","arguments":{}}}'

Use with the SDK

Install @pipeworx/sdk to call tools from any TypeScript/Node project.

TypeScript 
import { Pipeworx } from '@pipeworx/sdk';
const px = new Pipeworx();
const result = await px.call("datasets", {});
ask_pipeworx 
// Or ask in plain English:
const answer = await px.ask("connecticut open data — us government open data (data");