Skip to main content
Glama
pipeworx-io

mcp-data-connecticut

by pipeworx-io

mcp-data-connecticut

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

Part of Pipeworx — an MCP gateway connecting AI agents to 1394+ live data sources.

Tools

Tool

Description

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.

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. Returns matching rows as JSON.

metadata

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

Related MCP server: data-michigan

Quick Start

Add to your MCP client (Claude Desktop, Cursor, Windsurf, etc.):

{
  "mcpServers": {
    "data-connecticut": {
      "url": "https://gateway.pipeworx.io/data-connecticut/mcp"
    }
  }
}

Or connect to the full Pipeworx gateway for access to all 1394+ data sources:

{
  "mcpServers": {
    "pipeworx": {
      "url": "https://gateway.pipeworx.io/mcp"
    }
  }
}

Using with ask_pipeworx

Instead of calling tools directly, you can ask questions in plain English:

ask_pipeworx({ question: "your question about Data Connecticut data" })

The gateway picks the right tool and fills the arguments automatically.

More

License

MIT

A
license - permissive license
-
quality - not tested
C
maintenance

Maintenance

Maintainers
Response time
Release cycle
Releases (12mo)
Commit activity

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Related MCP Servers

  • A
    license
    -
    quality
    C
    maintenance
    Enables AI agents to query and retrieve San Francisco open data from data.sfgov.org via the Socrata SODA API.
    7
    MIT
  • A
    license
    -
    quality
    C
    maintenance
    Enables AI agents to search and query the Michigan Open Data catalog, running Socrata SoQL queries against datasets by resource ID, and retrieving dataset metadata.
    8
    MIT
  • A
    license
    -
    quality
    C
    maintenance
    Enables searching and querying Orlando Open Data datasets via Socrata SoQL, providing access to metadata and data rows through natural language or direct tool calls.
    8
    MIT

View all related MCP servers

Related MCP Connectors

View all MCP Connectors

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/pipeworx-io/mcp-data-connecticut'

If you have feedback or need assistance with the MCP directory API, please join our Discord server