Skip to main content
Glama

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault

No arguments

Instructions

Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.

This server publishes no instructions, or was last inspected before Glama recorded them.

Capabilities

Features and capabilities supported by this server

Protocol revision2025-11-25

CapabilityDetails
tools
{}
resources
{}

Tools

Functions exposed to the LLM to take actions

NameDescription
list_connectionsB

List all available database connections

get_connection_infoB

Get detailed information about a specific database connection

execute_queryA

Execute a SQL query on a specific database connection (read-only queries)

write_queryC

Execute INSERT, UPDATE, or DELETE queries on a specific database connection

create_tableB

Create new tables in the database

alter_tableB

Modify existing table schema (add columns, rename tables, etc.)

drop_tableA

Remove a table from the database with safety confirmation

get_table_schemaB

Get schema information for a specific table

export_dataC

Export query results to various formats (CSV, JSON, etc.)

test_connectionB

Test connectivity to a database connection

get_database_statsA

Get statistics and information about a database

list_tablesB

List all tables in a database

append_insightA

Add a business insight or analysis note to the memo

list_insightsA

List all stored business insights and analysis notes

begin_transactionC

Start a new database transaction

commit_transactionB

Commit an active transaction

rollback_transactionB

Rollback an active transaction

execute_in_transactionB

Execute a query within an active transaction

explain_queryB

Get the execution plan for a SQL query

compare_schemasB

Compare schemas between two database connections

get_pool_statsB

Get connection pool statistics for a connection

get_ssh_tunnel_infoA

Get the SSH tunnel / jump host profile associated with a database connection, as configured in the DB client's workspace (network handler config). Secrets are redacted; use test_connection to verify the tunnel actually connects.

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Latest Blog Posts

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/sangamkotalwar/omnisql-mcp'

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