• DATA
  • ANALYSIS
  • REPORTS
  • HUMAN

How to query Brazilian trade data with your AI

Connect the MDIC (Comércio Exterior) MCP to your agent. Once connected, you can pull specific trade statistics using natural language or SQL-like filters.

Ask AI about this page

Short answer

How can I pull specific MDIC trade rows with my AI?

Your AI uses the search_datastore tool to filter through MDIC datasets based on your specific parameters. You get precise rows of trade statistics without manual CSV downloads or complex database queries.

The results you get

What your queries produce

The AI handles the data retrieval so you can focus on the analysis.

DATA

Filtered trade rows

The AI uses search_datastore to find exact matches for NCM codes, periods, or countries. You receive clean, structured data instead of massive files.

ANALYSIS

Instant summaries

Once the data is pulled, your agent can immediately calculate totals or identify trends. You skip the step of importing data into a spreadsheet.

REPORTS

Custom trade tables

Ask for specific columns or groupings. Your AI formats the MDIC statistics into a readable table right in your chat window.

HUMAN

Strategic decisions

The AI provides the numbers, but you decide what the trade shifts mean for your business. You interpret the results and set your next move.

The workflow

What your AI does when the query arrives.

The AI acts as a bridge between your natural language request and the MDIC datasets.

  1. Parse parameters

    Your agent reads your request to identify specific NCM codes, timeframes, or country filters needed for the query.

    search_datastore

  2. Locate data

    The AI searches the MDIC datastore to find the specific rows that match your criteria.

    search_datastore

  3. Filter and format

    The agent narrows down the results to the exact columns you asked for, such as value, weight, or quantity.

    search_datastore

  4. Present results

    The AI delivers the final trade statistics as a structured response in your chat interface.

    search_datastore

Try it

Copy these to start.

Use these prompts to begin querying MDIC data.

Starting points

Swap out the NCM codes, countries, and dates with the specific ones you need to investigate.

MDIC (Comércio Exterior) Connector

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

Connector linkhttps://edge.vinkius.com/vk_preview_1xOtTiA1YhXf8erYNsnS7Vh8JrZt1rOsIN1Nw0KP/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 — MDIC (Comércio Exterior) capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "mdic-comercio-exterior-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_1xOtTiA1YhXf8erYNsnS7Vh8JrZt1rOsIN1Nw0KP/mcp"
    }
  }
}
Copy into chat04

  • Find the total export value for NCM 8471 in 2023.

  • Show me the top 5 countries that imported Brazilian soy in the last quarter.

  • List the import volume for NCM 8517 from China between January and June.

  • Compare the export values of NCM 3004 between 2022 and 2023.

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

Start here

Connect MDIC (Comércio Exterior) once, then ask.

Click the link to connect the MCP to your client. Your credentials stay encrypted, and you can start querying immediately.

Connect MDIC (Comércio Exterior) to your AI

FAQ

How this task behaves

  • 01

    Can the AI change the data in the MDIC database?

    No. The AI can only read and query the data using the search_datastore tool. It cannot modify or delete any official records.

  • 02

    Do I need to know SQL to use this?

    No. You can use plain English to describe the filters you want, and the AI will translate that into the necessary parameters.

  • 03

    Can the AI generate a PDF report of the trade data?

    No. The AI provides the data and tables within your chat interface. You would need to copy that data if you want to create a separate document.

  • 04

    Can I query data for specific NCM codes?

    Yes. You can specify any NCM code in your prompt to narrow down the results.

  • 05

    Does the AI handle the data cleaning?

    Yes. The AI pulls the raw data and formats it into a clean, readable structure for you.

  • More questions about MDIC (Comércio Exterior)? The Connector page answers them. See everything the MDIC (Comércio Exterior) Connector can do

Connect MDIC (Comércio Exterior) to Claude, Cursor, ChatGPT & more