Loading...
pip install uv{
"mcpServers": {
"my_database": {
"command": "uv",
"args": ["--directory", "/path/to/mcp-sqlalchemy-server", "run", "mcp-sqlalchemy-server"],
"env": {
"ODBC_DSN": "dsn_name",
"ODBC_USER": "username",
"ODBC_PASSWORD": "password",
"API_KEY": "sk-xxx"
}
}
}
}podbc_get_schemasRetrieves a list of available database schemas.
Read-only operation, no data modification.
podbc_get_tablesLists tables within a specified database schema.
Read-only operation, no data modification.
podbc_describe_tableProvides details about the structure of a specified table.
Read-only operation, no data modification.
podbc_filter_table_namesLists tables based on a substring pattern.
Read-only operation, no data modification.
podbc_query_databaseExecutes a SQL query and returns results in JSON format.
Potential SQL injection if the query is not properly sanitized.
podbc_execute_queryExecutes a SQL query and returns results in JSONL format.
Potential SQL injection if the query is not properly sanitized.
podbc_execute_query_mdExecutes a SQL query and returns results in Markdown table format.
Potential SQL injection if the query is not properly sanitized.
podbc_spasql_queryExecutes a SPASQL query (Virtuoso-specific).
SPASQL queries can modify data or execute SPARQL queries with potential side effects.
podbc_sparql_queryExecutes a SPARQL query (Virtuoso-specific).
SPARQL queries can potentially have side effects depending on the endpoint configuration.
podbc_virtuoso_support_aiInteracts with the Virtuoso Support Assistant/Agent using a prompt.
Interaction with AI assistant might lead to unintended actions based on the prompt.
This server offers both read and write capabilities to a database. It's safe for read-only operations like schema exploration and table description. However, executing arbitrary SQL queries and stored procedures poses a moderate risk due to potential SQL injection and unintended side effects.