Json To Sql MCP tool
findutils:json_to_sql Convert a JSON array of objects into SQL INSERT statements, optionally preceded by a CREATE TABLE. Column types come from the real JSON values, so booleans stay booleans and null becomes NULL rather than the text "null". A nested object or array is stored as JSON text. Identifiers are quoted for the chosen dialect (Postgres, MySQL or SQLite). A single object is treated as one row, and NDJSON is accepted. Nothing is executed against a database.
Arguments
application/json-
json
string required
A JSON array of objects, a single object, or NDJSON.
-
table
string optional
Target table name. Default: "my_table". Default
"my_table". -
dialect
string optional
Identifier quoting and type names. Default: postgres. One of
postgres · mysql · sqlite. Default"postgres". -
create_table
boolean optional
Emit a CREATE TABLE before the inserts. Default: true. Default
true. -
batch
boolean optional
Emit multi-row INSERTs instead of one statement per row. Default: false. Default
false.
Example arguments
Verified{
"json": [
{
"id": 1,
"name": "Ada",
"active": true
}
],
"table": "people",
"dialect": "postgres"
}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.