• DATA
  • ANALYSIS
  • REPORTS
  • HUMAN

How to query government datasets with your AI

Connect your AI to the Maranhão DataStore to pull live public data using SQL. Once connected, you can ask for specific records without manual exports.

Ask AI about this page

Short answer

How can I query Maranhão government data with my AI?

Your AI writes and runs SQL queries against the Maranhão DataStore to find specific records. You get structured data back immediately. You'll see how the process works below.

Where the data goes

What you get from your queries

The AI handles the database logic so you can focus on the information.

DATA

Direct SQL extraction

The AI pulls specific rows from the Maranhão DataStore. You get the exact records you asked for.

ANALYSIS

Instant data summaries

Your AI can summarize trends or count occurrences within the data it just pulled.

REPORTS

Structured data output

The AI turns database rows into clean tables you can use in your own work.

HUMAN

Manual validation

You must check the SQL logic and verify that the results match your research needs.

The workflow

What your AI does when you ask for data.

The AI acts as the bridge between your questions and the SQL database.

  1. Translate intent

    Your AI interprets your request for government records and converts it into a valid SQL query.

    search_datastore_sql

  2. Execute query

    The AI sends the command to the Maranhão DataStore to find the matching records.

    search_datastore_sql

  3. Format results

    The AI takes the raw database output and organizes it into a readable format for your chat.

    search_datastore_sql

  4. Refine search

    If the data isn't right, you tell the AI to adjust the filters or add more conditions.

    search_datastore_sql

Try it

Copy these to start.

Use these prompts to begin interacting with the Maranhão DataStore.

Starting points

Swap the bracketed text for the specific table names or columns you need from the Maranhão datasets.

Maranhão Open Data Connector

You're all set. Choose your MCP client and follow the setup instructions.

Connector linkhttps://edge.vinkius.com/vk_preview_ltM6hp390inTajhBbBQzzrjnzpsG4dX6a1IKEuJL/mcp

Claude Desktop

Follow the steps below to connect in seconds.

  1. 1In Claude Desktop, open Settings → Connectors.
  2. 2Click “Add custom connector” and paste the connector link above as the remote MCP server URL.
  3. 3Click Add and start a new chat — Maranhão Open Data capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "maranhao-open-data-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_ltM6hp390inTajhBbBQzzrjnzpsG4dX6a1IKEuJL/mcp"
    }
  }
}
Copy into chat04

  • Search the Maranhão DataStore for all records in the [table_name] table.

  • Find the top 10 entries in [table_name] where the [column_name] is greater than 100.

  • Run a SQL query to count how many rows in [table_name] have a value of 'active' in the [status_column].

  • List the most recent 5 entries from the [table_name] dataset.

  • Claude
  • ChatGPT
  • Cursor
  • VS Code
  • Windsurf
  • Claude Code
  • JetBrains
  • Cline

Start here

Connect Maranhão Open Data once, then ask.

One click connects your client. Your login stays encrypted, and you can start querying immediately.

Connect Maranhão Open Data to your AI

FAQ

How this task behaves

  • 01

    Can the AI change or delete data in the government database?

    No. The tool only allows for searching and reading data via SQL. It cannot modify or delete any records.

  • 02

    Do I need to know SQL to use this?

    No. You can ask questions in plain English, and your AI will write the SQL code for you.

  • 03

    Can the AI export these results directly to a CSV file?

    No. The AI can present the data in a table within your chat, but you must manually copy it if you want a file.

  • 04

    What happens if my SQL query is wrong?

    If the AI generates a query that the database rejects, it will see the error and try to fix the syntax.

  • 05

    Can I query any dataset in Brazil?

    No. This connector only provides access to the datasets hosted in the Maranhão DataStore.

  • More questions about Maranhão Open Data? The Connector page answers them. See everything the Maranhão Open Data Connector can do

Connect Maranhão Open Data to Claude, Cursor, ChatGPT & more