Skip to main content

Available Tools

Connection Management​

list_connections​

List all DBeaver database connections.

Parameters:

  • includeDetails (optional): Include detailed connection info

get_connection_info​

Get details about a specific connection.

Parameters:

  • connectionId (required): Connection ID or name

test_connection​

Test if a connection works.

Parameters:

  • connectionId (required): Connection ID or name

Data Operations​

execute_query​

Run SELECT queries (read-only).

Parameters:

  • connectionId (required): Connection ID or name
  • query (required): SQL SELECT statement
  • maxRows (optional): Max rows to return (default: 1000)

write_query​

Run INSERT, UPDATE, or DELETE queries.

Parameters:

  • connectionId (required): Connection ID or name
  • query (required): SQL statement

export_data​

Export query results.

Parameters:

  • connectionId (required): Connection ID or name
  • query (required): SQL SELECT statement
  • format (optional): csv or json (default: csv)
  • includeHeaders (optional): Include headers (default: true)
  • maxRows (optional): Max rows (default: 10000)

Schema Management​

list_tables​

List tables and views.

Parameters:

  • connectionId (required): Connection ID or name
  • schema (optional): Schema to list from
  • includeViews (optional): Include views (default: false)

get_table_schema​

Get table structure.

Parameters:

  • connectionId (required): Connection ID or name
  • tableName (required): Table name
  • includeIndexes (optional): Include indexes (default: true)

create_table​

Create a table.

Parameters:

  • connectionId (required): Connection ID or name
  • query (required): CREATE TABLE statement

alter_table​

Modify a table.

Parameters:

  • connectionId (required): Connection ID or name
  • query (required): ALTER TABLE statement

drop_table​

Drop a table (requires confirmation).

Parameters:

  • connectionId (required): Connection ID or name
  • tableName (required): Table to drop
  • confirm (required): Must be true

Other​

get_database_stats​

Get database statistics.

Parameters:

  • connectionId (required): Connection ID or name

append_insight​

Store an analysis note.

Parameters:

  • insight (required): Note text
  • connection (optional): Associated connection
  • tags (optional): Array of tags

list_insights​

Retrieve stored notes.

Parameters:

  • connection (optional): Filter by connection
  • tags (optional): Filter by tags

Safety Levels​

  • Safe: Read-only, no side effects
  • Modifies data: Changes data, not schema
  • Schema changes: Modifies database structure
  • Destructive: Permanently removes data/objects (requires confirmation)