mcp-ads mcp

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

Advantage Database Server (ADS) 12+ via FireDAC native driver. Supports server mode (network) and local/embedded mode. Operations: query (SELECT → rows JSON), execute (INSERT/UPDATE/DELETE/DDL), execute_tx (transaction), list_tables (sp_GetTables), describe (sp_GetColumns). database = path to ADS data dictionary (.add) or directory. Requires Advantage Client Engine (ace64.dll).

adsadvantagedatabasesqlfiredacdbaselegacy

Input Parameters

ParameterTypeDescription
operationrequired string Operation to perform. One of: query, execute, execute_tx, list_tables, describe, list_databases.
databaserequired string Path to ADS data dictionary file (.add) or directory containing ADS tables (e.g. 'C:\data\myapp.add' or '\\server\share\data\').
hostoptional string ADS server hostname or IP for remote/server mode. Omit for local/embedded mode.
portoptional integer ADS server port. Default: 6262. Default: 6262.
usernameoptional string ADS username (for server mode with authentication).
passwordoptional string ADS password.
sQLoptional string SQL statement. Required for query and execute. ADS supports standard SQL with TOP N for row limiting.
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 in local/embedded mode

// Input
{
  "operation": "query",
  "database": "C:\\data\\myapp.add",
  "sQL": "SELECT TOP 10 ID, Name, Balance FROM Customers ORDER BY Name"
}

// Output
{
  "ok": true,
  "rows": []
}

Query via ADS server

// Input
{
  "operation": "query",
  "host": "adsserver",
  "database": "\\\\adsserver\\share\\data\\",
  "username": "admin",
  "password": "secret",
  "sQL": "SELECT TOP 5 * FROM Orders WHERE Status = 'PENDING'"
}

// Output
{
  "ok": true,
  "rows": []
}

List tables

// Input
{
  "operation": "list_tables",
  "database": "C:\\data\\myapp.add"
}

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

Install & Discovery

Install

ppm install mcp-ads

Get JSON Schema

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

Discover by keyword

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