MySQL MCP Server

by pickstar-2002

MIT License

Overview InspectNew Endpoints Schema Related Servers Reviews Score

mysql_import_data

Import data from CSV or JSON files into MySQL tables. Use the tool to specify table name, file path, format, and optional truncation to streamline data loading processes.

Instructions

从文件导入数据到表

Input Schema

Name	Required	Description
`filePath`	Yes	导入文件路径
`format`	Yes	文件格式
`tableName`	Yes	表名称
`truncateFirst`	No	是否先清空表

Input Schema (JSON Schema)

{
  "properties": {
    "filePath": {
      "description": "导入文件路径",
      "type": "string"
    },
    "format": {
      "description": "文件格式",
      "enum": [
        "csv",
        "json"
      ],
      "type": "string"
    },
    "tableName": {
      "description": "表名称",
      "type": "string"
    },
    "truncateFirst": {
      "default": false,
      "description": "是否先清空表",
      "type": "boolean"
    }
  },
  "required": [
    "tableName",
    "filePath",
    "format"
  ],
  "type": "object"
}

This server cannot be installed

Other Tools from MySQL MCP Server

Related Tools

mysql_insert
@pickstar-2002/mysql-mcp
pg_import_table_data
@HenkDz/postgresql-mcp-server
mysql_export_data
@pickstar-2002/mysql-mcp
insert_data
@alittleyellowkevin/Mysql-MCP
load_csv
@santoshray02/csv-editor
parse_sheet
@yuqie6/MCP-Sheet-Parser-cot

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/pickstar-2002/mysql-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server