OpenGov MCP Companion Skill v9+

Construct and execute SoQL queries through the OpenGov MCP Server.

1|Updated Nov 3, 2025
One-click install
npx skills add https://github.com/npstorey/civic-ai-tools-old --skill opengov-mcp-companion-skill-v9
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: OpenGov MCP Companion Skill v9+
Source: https://github.com/npstorey/civic-ai-tools-old/tree/main/skills/opengov-mcp-companion
Command: npx skills add https://github.com/npstorey/civic-ai-tools-old --skill opengov-mcp-companion-skill-v9

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

The OpenGov MCP Companion Skill enables LLMs to interact safely and efficiently with Socrata portals through the OpenGov MCP Server, reducing manual query setup and minimizing hallucinations.

Core Features & Use Cases

  • Multi-domain data access across NYC, Chicago, SF, Seattle, and LA
  • Intelligent query assessment and anti-hallucination protocols
  • Reproducible analysis code and downloadable data exports
  • Quick-start templates for common civic data tasks (aggregations, time series, distributions)

Quick Start

Use the OpenGov MCP Companion Skill to construct and execute SoQL queries through get_data, starting with column discovery and transparent output formats.

Frequently Asked Questions about OpenGov MCP Companion Skill v9+

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I query Socrata open data portals using an LLM without hallucinating columns?

To query Socrata open data portals without hallucinating columns, this Skill enforces column-discovery protocols and anti-hallucination rules, guiding the LLM to construct standardized SoQL queries through the OpenGov MCP Server for accurate results.

What is the best way to standardize SoQL query construction across multiple municipal domains?

The best way to standardize SoQL query construction across multiple municipal domains is by using this Skill to enforce consistent query formatting, error handling, and domain-specific nuances when accessing data from NYC, Chicago, SF, Seattle, and LA.

Can I use the OpenGov MCP Server to access civic data from multiple cities simultaneously?

Yes, you can use the OpenGov MCP Server to access civic data from multiple cities simultaneously, as this Skill supports multi-domain data access across NYC, Chicago, SF, Seattle, and LA with standardized output formatting and reproducible analysis code.

How do I get started with SoQL queries for common civic data tasks like aggregations and time series?

You can get started with SoQL queries for common civic data tasks like aggregations and time series by using this Skill's quick-start templates, which guide the LLM through column discovery and transparent output formats via the get_data function.

Does this approach to querying open data provide reproducible analysis code and downloadable exports?

Yes, this approach to querying open data provides reproducible analysis code and downloadable data exports, ensuring that your LLM-generated SoQL queries and civic data results can be reliably shared and verified.