MCPVault

get_table_columns

MCP tool from Legion MCP by TheRaLabs

Get column names for a specific table

How to use it

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

Install Legion MCP

$npx @modelcontextprotocol/inspector uv run src/database_mcp/mcp_server.py
FULL LEGION MCP LISTING

Other tools in Legion MCP (9)

describe_table

Get detailed description of a table including column names and types

execute_query

Execute a SQL query and return results as a markdown table

execute_query_json

Execute a SQL query and return results as JSON

find_table

Find which database contains a specific table

get_database_info

Get detailed information about a database including schema

get_query_history

Get the recent query history

get_table_sample

Get a sample of data from a table

get_table_types

Get column types for a specific table

list_databases

List all available database connections