• FILE
  • QUERY
  • STREAM
  • HUMAN

How to export database data with your AI

Connect DBeaver to your AI client once. From there, you just tell your agent which data to grab and what format you want it in.

Ask AI about this page

Short answer

How can I export database data using my AI?

You tell your agent to run a query or select a table, then instruct it to export those results into a CSV or JSON file. It handles the asynchronous transfer so you get clean files ready for use.

The results

Where your data lands

The AI handles the heavy lifting of moving data from your database to files.

FILE

Local data files

The AI turns database rows into CSV or JSON files. You get the files ready to use in other apps.

QUERY

Custom result sets

Your agent can run a specific SQL query and export only the rows that match your criteria.

STREAM

Processed data streams

The AI can apply stream processors to the data during the export. This lets you clean or transform the data as it moves.

HUMAN

Manual verification

The AI handles the transfer, but you stay in control. You decide which queries are safe to run and which files are ready.

The workflow

What your AI does when the export request arrives.

The AI moves from reading your database to generating a downloadable file.

  1. Identify the source

    Your agent looks at your DBeaver connection to find the specific table or container you want to export.

    data_transfer_export_data_from_container

  2. Run the query

    If you asked for specific data, the AI executes the SQL and holds the resulting set in memory.

    data_transfer_export_data_from_results

  3. Process the data

    The AI can pass the data through available stream processors to format or filter it before it hits the disk.

    data_transfer_available_stream_processors

  4. Finalize the file

    The AI completes the asynchronous transfer, creating the final CSV or JSON file for you to download.

    data_transfer_export_data_from_results

Try it

Copy these to start.

Use these prompts to trigger your first export.

Starting points

These are opening lines. Swap the bracketed text for your actual table names or query logic.

CloudBeaver Connector

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

Connector linkhttps://edge.vinkius.com/vk_preview_E9SNBrPcj6htJ3fU0RopCN0dEOsUlh20fAVZditP/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 — CloudBeaver capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "dbeaver-cloudbeaver-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_E9SNBrPcj6htJ3fU0RopCN0dEOsUlh20fAVZditP/mcp"
    }
  }
}
Copy into chat04

  • Export the contents of the [users] table to a CSV file.

  • Run the query [SELECT * FROM orders WHERE status = 'pending'] and save the results as JSON.

  • Take the data from the [inventory] container and export it using a stream processor.

  • Find all records in the [customers] table where the last_login was yesterday and export them to CSV.

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

Start here

Connect DBeaver once, then ask.

Just click the link to connect your DBeaver instance. Your credentials stay encrypted, and you can start prompting immediately.

Connect DBeaver to your AI

FAQ

How this task behaves

  • 01

    Can the AI delete my database tables?

    No. The tools provided only allow for reading and exporting data. The AI cannot perform DELETE or DROP operations.

  • 02

    What file formats can I use?

    You can export data into CSV or JSON formats.

  • 03

    Does the AI change the data in my database?

    No. The export process is read-only. It pulls data out of your database but does not modify the source tables.

  • 04

    Can I export massive datasets?

    Yes. The AI uses asynchronous transfers to handle the data movement in the background.

  • 05

    Can the AI write new SQL queries for me?

    Yes, your agent can write the queries, but it only executes them through the specific export tools provided by the MCP.

  • More questions about DBeaver? See everything the DBeaver Connector can do

Connect CloudBeaver to Claude, Cursor, ChatGPT & more