Sql To Csv MCP tool
findutils:sql_to_csv Read rows out of SQL INSERT statements and return CSV, one file per table. Parses a mysqldump, pg_dump or SQLite dump as text — nothing is executed against a database. Column names come from the INSERT column list, then from a CREATE TABLE in the same input, then from positions. NULL becomes an empty cell. Dump noise such as SET, LOCK TABLES and comments is ignored, and an INSERT ... SELECT with no literal VALUES is reported rather than guessed at.
Arguments
application/json-
sql
string required
SQL dump text containing INSERT statements.
-
table
string optional
Return only this table. Default: every table found.
-
delimiter
string optional
Output field separator. Default: a comma. Default
",". -
max_rows
integer optional
Stop after this many rows per table. Default 50000, maximum 200000. Default
50000.
Example arguments
Verified{
"sql": "INSERT INTO people (id, name) VALUES (1, 'Ada'), (2, 'Doe, John');"
}More Data tools
- Api Docs Generator Return API documentation generated from a list of endpoints, as Markdown (with table of contents, request/response examples) or as an OpenAP
- Bookmarks Html To Csv Convert a browser bookmarks.html export from Chrome, Firefox, Edge, Safari or any other browser that writes the Netscape bookmark format int
- Csv To Bookmarks Html Convert a CSV of links into a Netscape bookmarks.html file that Chrome, Firefox, Edge and Safari import.
- Csv To Json Parse CSV text into an array of objects keyed by the header row.
- Csv To Ndjson Convert CSV into newline-delimited JSON (NDJSON, JSON Lines, .jsonl): one JSON object per line, keyed by the header row.
- Csv To Sql Convert CSV text into SQL INSERT statements, optionally preceded by a CREATE TABLE.