Skip to main content
Glama

Panther MCP Server

Official
Apache 2.0
16
  • Apple

get_table_schema

Retrieve detailed column information for a specific datalake table, including names and data types, to optimize query writing. Combine with log schema for nested structures and field mappings.

Instructions

Get column details for a specific datalake table.

IMPORTANT: This returns the table structure in Snowflake/Redshift. For writing optimal queries, ALSO call get_panther_log_type_schema() to understand: - Nested object structures (only shown as 'object' type here) - Which fields map to p_any_* indicator columns - Array element structures Example workflow: 1. get_panther_log_type_schema(["AWS.CloudTrail"]) - understand structure 2. get_table_schema("panther_logs.public", "aws_cloudtrail") - get column names/types 3. Write query using both: nested paths from log schema, column names from table schema Returns: Dict containing: - success: Boolean indicating if the query was successful - name: Table name - display_name: Table display name - description: Table description - log_type: Log type - columns: List of columns, each containing: - name: Column name - type: Column data type - description: Column description - message: Error message if unsuccessful

Input Schema

NameRequiredDescriptionDefault
database_nameYesThe name of the database where the table is located
table_nameYesThe name of the table to get columns for

Input Schema (JSON Schema)

{ "properties": { "database_name": { "description": "The name of the database where the table is located", "example": "panther_logs.public", "title": "Database Name", "type": "string" }, "table_name": { "description": "The name of the table to get columns for", "example": "Panther.Audit", "title": "Table Name", "type": "string" } }, "required": [ "database_name", "table_name" ], "type": "object" }

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/panther-labs/mcp-panther'

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