MCPVault

show_create_table

MCP tool from Mysql MCP Server by askdba

Get the CREATE TABLE statement.

How to use it

show_create_table is exposed by the Mysql MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the show_create_table tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.

FULL MYSQL MCP SERVER LISTING

Other tools in Mysql MCP Server (26)

add_connection

MCP only. Available when the server runs in MCP mode (stdio) with MYSQLMCPEXTENDED=1 and MYSQLMCPENABLEADDCONNECTION=1. It registers a new named MySQL connection at runtime and switches the process-wide active connection for that MCP process. There is no HTTP route to register a new DSN. REST API mo

database_size

Get database size information.

describe_table

Input:

description

No

dsn

Yes

explain_query

Get execution plan for a SELECT query. Responses include optional warnings (e.g. full table scan, filesort) when the plan suggests optimizations.

foreign_keys

List foreign key constraints.

list_connections

List all configured MySQL connections.

list_databases

Returns non-system databases.

list_functions

List stored functions.

list_indexes

List indexes on a table.

list_partitions

List table partitions.

list_procedures

List stored procedures.

list_status

List MySQL server status variables.

list_tables

Input:

list_triggers

List triggers in a database.

list_variables

List MySQL server configuration variables.

list_views

List views in a database.

name

Yes

ping

Tests database connectivity and returns latency.

run_query

Input:

server_info

Returns MySQL server details.

table_size

Get table size information.

use_connection

Switch to a different MySQL connection.

vector_info

List vector columns in a database.

vector_search

Perform similarity search on vector columns.