mcp-sybase mcp

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

SAP SQL Anywhere (formerly Sybase ASA) via FireDAC native driver. Operations: query (SELECT → rows JSON), execute (INSERT/UPDATE/DELETE/DDL), execute_tx (transaction), list_tables, describe (columns), list_databases (schemas). Default port: 2638. Requires SQL Anywhere client libraries (dbodbc17.dll / dbodbc19.dll).

sybasesapsqlanywhereasadatabasesqlfiredac

Input Parameters

Parameter	Type	Description
operationrequired	string	Operation to perform. One of: `query`, `execute`, `execute_tx`, `list_tables`, `describe`, `list_databases`.
hostrequired	string	SQL Anywhere server host or IP (e.g. 'localhost', '192.168.1.40').
portoptional	integer	SQL Anywhere port. Default: 2638. Default: `2638`.
databaserequired	string	Database name or service name (e.g. 'demo', 'sa_demo').
usernameoptional	string	SQL Anywhere username (e.g. 'DBA').
passwordoptional	string	SQL Anywhere password.
sQLoptional	string	SQL statement. Required for query and execute.
sQLListoptional	string	JSON array string of SQL statements for execute_tx.
tableoptional	string	Table name. Required for describe.
schemaoptional	string	Schema filter for list_tables and 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

Field	Type	Description
ok	boolean
rows	array[object]
affected	integer
tables	array[object]
columns	array[object]
databases	array[string]
error	string

Examples

Query from SQL Anywhere

// Input
{
  "operation": "query",
  "host": "localhost",
  "database": "demo",
  "username": "DBA",
  "password": "sql",
  "sQL": "SELECT TOP 10 ID, Name FROM Customers ORDER BY Name"
}

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

List tables

// Input
{
  "operation": "list_tables",
  "host": "localhost",
  "database": "demo",
  "username": "DBA",
  "password": "sql"
}

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

Install & Discovery

Install

ppm install mcp-sybase

Get JSON Schema

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

Discover by keyword

GET /v1/mcp/discover?q=sybase

Discovery hint: Install with ppm install mcp-sybase or invoke remotely via POST /v1/invoke/mcp-sybase on the MCP Service.