SQL MCP Server

get_columns

Retrieve a list of columns from a specified table in SQL databases (Postgres, MySQL, SQLite) using database connection details. Streamline schema analysis and database management tasks.

Instructions

Get list of column in a table

Input Schema

Name	Required	Description	Default
`connection_string`	Yes
`db_type`	Yes
`table_name`	Yes

Input Schema (JSON Schema)

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false,
  "properties": {
    "connection_string": {
      "type": "string"
    },
    "db_type": {
      "enum": [
        "postgres",
        "mysql",
        "sqlite"
      ],
      "type": "string"
    },
    "table_name": {
      "type": "string"
    }
  },
  "required": [
    "db_type",
    "connection_string",
    "table_name"
  ],
  "type": "object"
}

Install Server

HTTP connection URL

Other Tools from SQL MCP Server

Related Tools

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/adetxt/sql-mcp'

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