• DATA
  • FILES
  • ACTION
  • READY

How to export data queries to CSV with your AI

Connect Omni BI Intelligence to your AI client once. After that, you can pull data from your models and get CSV files immediately.

Ask AI about this page

Short answer

How can I get CSV files from my Omni queries using AI?

Tell your AI what data you need from your Omni models. It will run the query and give you a direct download link for the CSV. You'll see exactly how it works below.

The outcomes

What you get

This is what happens after you give your AI a command.

DATA

Query results

The AI pulls the specific rows and columns you asked for from your Omni models.

FILES

CSV download links

The AI generates a link so you can grab the data as a spreadsheet file.

ACTION

Human review

You check the data to make sure it's correct before you use it elsewhere.

READY

Local files

The CSV lands on your machine, ready for Excel, Sheets, or Python.

The workflow

What your AI does when the request arrives.

The AI handles the heavy lifting of talking to the Omni API.

  1. Translate request

    Your AI interprets your natural language into a structured query that Omni understands.

    run_omni_query

  2. Fetch data

    The AI executes the query against your specific Omni models to pull the raw data.

    run_omni_query

  3. Convert to CSV

    The AI takes those query results and packages them into a downloadable format.

    export_query_results

  4. Deliver link

    The AI provides a direct URL in the chat so you can download the file immediately.

    export_query_results

Try it

Copy these to start.

Use these prompts to trigger your first data export.

Starting points

Swap out the bracketed text for your actual model names or specific column requirements.

Omni BI Connector

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

Connector linkhttps://edge.vinkius.com/vk_preview_0gznQu1XVWP1sAGGLhUvTXTBwtHKt2KwkuA0UKRm/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 — Omni BI capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "omni-bi-intelligence-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_0gznQu1XVWP1sAGGLhUvTXTBwtHKt2KwkuA0UKRm/mcp"
    }
  }
}
Copy into chat04

  • Run a query on the Sales model for all transactions in Q3 and give me a CSV link.

  • Export a list of all active users from the User model to a CSV file.

  • Get the total revenue by region from the Finance model and provide a download link.

  • Query the Inventory model for items with low stock and export the results to CSV.

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

Start here

Connect Omni BI Intelligence once, then ask.

Click the link to connect your account. Your credentials stay encrypted, and you can start querying immediately in any compatible client.

Connect Omni BI Intelligence to your AI

FAQ

How this task behaves

  • 01

    Can the AI change my Omni model definitions?

    No. The AI can only read data and export results; it cannot modify your models.

  • 02

    Will the AI delete any data in Omni?

    No. This MCP only has tools to run queries and export results. It has no permission to delete or edit data.

  • 03

    Do I need to write SQL to get my CSV?

    No. You can just tell your AI what you want in plain English, and it handles the query logic.

  • 04

    Can the AI upload the CSV directly to Google Sheets?

    No. The AI provides a download link for the CSV. You will need to upload that file to Sheets yourself.

  • 05

    Can I filter the data before it exports?

    Yes. You can include any filters or specific column requests in your prompt.

  • More questions about Omni BI Intelligence? The Connector page answers them. See everything the Omni BI Intelligence Connector can do

Connect Omni BI to Claude, Cursor, ChatGPT & more