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, a SQLite dump or a pg_dump made with --inserts as text — nothing is executed against a database. PostgreSQL COPY blocks (the pg_dump default) are not read. 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)…
- 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…
- Bookmarks Json To Html Convert a bookmarks JSON file into a Netscape bookmarks.html that Chrome, Firefox, Edge and Safari import.
- Csv Dedupe Remove duplicate rows from a CSV or TSV table.
- Csv Diff Compare two CSV or TSV tables by key column and list the rows that were added, removed or changed - a table diff, not a line diff, so rows…
- Csv To Bookmarks Html Convert a CSV of links into a Netscape bookmarks.html file that Chrome, Firefox, Edge and Safari import.