Which AI agent clients does Data Investigator integrate with?

It offers seamless integration with popular MCP clients such as Cursor and Claude Desktop, allowing for easy configuration and use by your AI agents.

What types of SQL operations can AI agents perform?

AI agents can execute both read-only queries (e.g., SELECT, SHOW) and critical write operations (e.g., INSERT, UPDATE, DELETE, CREATE) against MySQL databases.

What is Data Investigator?

Data Investigator is an MCP server that provides AI agents with a secure interface to execute SQL queries against MySQL databases, facilitating automated data interaction.

How does Data Investigator ensure data security, especially for write operations?

All write queries require mandatory user approval to prevent unauthorized changes. Additionally, access is secured with configurable API key authentication for AI agents.

Data Investigator

Name: Data Investigator
Author: webshoten

0•

Provides an MCP server interface for AI agents to execute SQL queries against MySQL databases.

The Data Investigator is a server that enables AI agents, such as those within Cursor or Claude Desktop, to interact with MySQL databases. It functions as an MCP (Model-Client Protocol) server, facilitating the execution of both read-only (SELECT, SHOW, DESCRIBE, EXPLAIN) and write (INSERT, UPDATE, DELETE, CREATE, DROP, ALTER) SQL queries. For enhanced security, all write operations require explicit user approval. The server also supports API key authentication, making it suitable for secure deployments in various environments.

Key Features

01Secure MySQL query execution for AI agents

02Mandatory user approval for all write queries

030 GitHub stars

04Seamless integration with popular MCP clients like Cursor and Claude Desktop

05Configurable API key authentication for secure access

06Supports both read-only and write SQL operations

Use Cases

01Building AI applications that require controlled and authenticated access to relational databases

02Enabling AI-driven data exploration and analysis directly from development environments

03Automating routine database administration tasks with AI agents under human supervision