=== dbx MCP functional test ===
binary: /tmp/dbx-test/node_modules/@dbx-app/mcp-darwin-arm64/bin/dbx-mcp
server: dbx v0.4.51 proto=2025-06-18
tools: ['dbx_add_connection', 'dbx_close_session', 'dbx_describe_table', 'dbx_execute_and_show', 'dbx_execute_query', 'dbx_execute_redis_command', 'dbx_get_schema_context', 'dbx_list_connections', 'dbx_list_tables', 'dbx_open_session', 'dbx_open_table', 'dbx_remove_connection']
init raw: {
  "protocolVersion": "2025-06-18",
  "capabilities": {
    "tools": {}
  },
  "serverInfo": {
    "name": "dbx",
    "version": "0.4.51"
  },
  "instructions": "Use DBX connections to inspect schemas and query databases safely."
}

add_connection: Connection "test-sqlite" added (id: 95390ad9-836e-4c06-806d-a97c169706f4).
list_connections: | ID | Name | Type | Host | Port | Database |
| --- | --- | --- | --- | --- | --- |
| 95390ad9-836e-4c06-806d-a97c169706f4 | test-sqlite | sqlite | /tmp/dbx-test/sample.db | 0 |  |
list_tables: - orders (BASE TABLE)
- users (BASE TABLE)
describe_table: | Column | Type | Nullable | Default | Comment |
| --- | --- | --- | --- | --- |
| id (PK) | INTEGER | YES |  |  |
| name | TEXT | YES |  |  |
| email | TEXT | YES |  |  |
| active | INTEGER | YES |  |  |
execute_query: | name | email |
|---|---|
| Ada Lovelace | ada@example.com |
| Alan Turing | alan@example.com |
(2 rows, 0ms)
drop_blocked: Error [SQL_BLOCKED]: High-risk SQL is disabled in DBX MCP settings.
schema_context len: 238

=== RESULTS ===
  initialize handshake: True
  tools/list returns tools: True
  dbx_add_connection sqlite: True
  dbx_list_connections shows test-sqlite: True
  dbx_list_tables shows users/orders: True
  dbx_describe_table users shows columns: True
  dbx_execute_query returns Ada and Alan: True
  write-protection: DROP blocked by default: True
  dbx_get_schema_context returns compact schema: True