mcp-sqlalchemy

Official
Apache 2.0
7
  • Apple
  • Linux

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
DB_URLYesSQLAlchemy URL for database connection (e.g., virtuoso+pyodbc://user:password@VOS)

Schema

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Tools

Functions exposed to the LLM to take actions

NameDescription
podbc_get_schemas

Retrieve and return a list of all schema names from the connected database.

podbc_get_tables

Retrieve and return a list containing information about tables in specified schema, if empty uses connection default

podbc_describe_table

Retrieve and return a dictionary containing the definition of a table, including column names, data types, nullable, autoincrement, primary key, and foreign keys.

podbc_filter_table_names

Retrieve and return a list containing information about tables whose names contain the substring 'q' in the format [{'schema': 'schema_name', 'table': 'table_name'}, {'schema': 'schema_name', 'table': 'table_name'}].

podbc_execute_query

Execute a SQL query and return results in JSONL format.

podbc_execute_query_md

Execute a SQL query and return results in Markdown table format.

podbc_query_database

Execute a SQL query and return results in JSONL format.

podbc_spasql_query

Execute a SPASQL query and return results.

podbc_sparql_query

Execute a SPARQL query and return results.

podbc_virtuoso_support_ai

Tool to use the Virtuoso AI support function

podbc_sparql_func

Call ???.

ID: d29eq2qygt