mcp-access mcp

v1.0.0 · MCP Tool · database · registry.pascalai.org

Microsoft Access (.accdb/.mdb) via FireDAC DAO driver. Operations: query (SELECT → rows JSON), execute (INSERT/UPDATE/DELETE/DDL), execute_tx (transaction), list_tables, describe (column names). database param = full file path to .accdb or .mdb. No host/port needed. Requires Microsoft Access Database Engine 2016+ Redistributable (64-bit).

accessmicrosoftdatabasesqlfiredacaccdbmdbjetdao

Input Parameters

ParameterTypeDescription
operationrequired string Operation to perform. list_databases returns the same as list_tables for Access. One of: query, execute, execute_tx, list_tables, describe, list_databases.
databaserequired string Full path to the Access database file (e.g. 'C:\data\sales.accdb' or 'C:\legacy\app.mdb').
passwordoptional string Database password if the Access file is password-protected.
sQLoptional string SQL statement. Required for query and execute. Access uses Jet SQL (TOP N instead of LIMIT, # for date literals).
sQLListoptional string JSON array string of SQL statements for execute_tx.
tableoptional string Table name. Required for describe.
maxRowsoptional integer Maximum rows to return for query. Default: 100. Default: 100.
timeoutoptional integer Query timeout in seconds. Default: 30. Default: 30.

Output Fields

FieldTypeDescription
ok boolean
rows array[object]
affected integer
tables array[object]
columns array[object]
error string

Examples

Query an Access database

// Input
{
  "operation": "query",
  "database": "C:\\data\\Northwind.accdb",
  "sQL": "SELECT TOP 10 CustomerID, CompanyName FROM Customers ORDER BY CompanyName"
}

// Output
{
  "ok": true,
  "rows": [
    {
      "CustomerID": "ALFKI",
      "CompanyName": "Alfreds Futterkiste"
    }
  ]
}

List all user tables

// Input
{
  "operation": "list_tables",
  "database": "C:\\data\\sales.accdb"
}

// Output
{
  "ok": true,
  "tables": [
    {
      "TABLE_NAME": "Orders"
    },
    {
      "TABLE_NAME": "Products"
    }
  ]
}

Insert a record

// Input
{
  "operation": "execute",
  "database": "C:\\data\\sales.accdb",
  "sQL": "INSERT INTO Customers (CustomerID, CompanyName) VALUES ('TEST1', 'Test Co')"
}

// Output
{
  "ok": true,
  "affected": 1
}

Install & Discovery

Install

ppm install mcp-access

Get JSON Schema

GET /v1/packages/mcp-access/1.0.0/schema

Discover by keyword

GET /v1/mcp/discover?q=access
Discovery hint: Install with ppm install mcp-access or invoke remotely via POST /v1/invoke/mcp-access on the MCP Service.