# PyODBC

> Use this tool when you need to access and query ODBC-compatible databases, including Virtuoso DBMS, to retrieve structured data through SQL, SPARQL, and SPASQL queries. It solves problems related to data analysis, reporting, and knowledge graph exploration by providing a lightweight bridge between AI assistants and databases. The tool accepts SQL queries as input and outputs results in JSONL and Markdown table formats, making it ideal for use in AI assistant workflows that require direct database access.

Canonical page: https://skillsregistry.net/skills/openlinksoftware-pyodbc  
JSON: https://api.skillsregistry.net/v1/skills/openlinksoftware-pyodbc

## Description

The MCP PyODBC Server provides a lightweight bridge between AI assistants and ODBC-compatible databases, with special optimizations for Virtuoso DBMS. Developed by OpenLink Software, it enables structured data access through SQL queries, table exploration, and schema discovery while also supporting specialized Virtuoso features like SPARQL and SPASQL queries. The server handles connection management, query execution, and result formatting in both JSONL and Markdown table formats, making it ideal for data analysis, reporting, and knowledge graph exploration directly within AI assistant workflows.

## Trust

- **Trust score (0–1):** 0.79
- **Verification tier:** verified
- **Last scanned:** 2026-09-28

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-09-28

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/openlinksoftware-pyodbc)
- **Repository:** <https://github.com/openlinksoftware/mcp-pyodbc-server>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "openlinksoftware-pyodbc"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/openlinksoftware-pyodbc` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/openlinksoftware-pyodbc/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt