crea-ddf-mcp

library0.0.4jsnpmunverified

Read-only MCP (Model Context Protocol) server for querying synced CREA DDF (Canadian Real Estate Association Data Distribution Facility) PostgreSQL data. Version 0.0.4, experimental/early release with no stated cadence. Key differentiator: exposes database tables (properties, members, offices, openHouses, destinations, watermarks, syncRuns, syncErrors) through structured tools and resources, does not handle API credentials or sync operations, relies on pre-synced data via crea-ddf package. Requires Node.js >=24.14.0 or Bun >=1.3.0. ESM-only, ships TypeScript types.

database ai-ml

npm install crea-ddf-mcp

github ↗package ↗homepage ↗

INSTALL

IMPORT

SIG · CREA-DDF-MCP

crea-ddf-mcp

databasejavascriptv0.0.4

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

crea-ddf-mcp (CLI)

✓ npx -y crea-ddf-mcp

✗ npm install -g crea-ddf-mcp && crea-ddf-mcp

The package is designed to run via npx; global install works but npx ensures latest version and avoids global conflicts.

process.env.DATABASE_URL

✓ process.env.DATABASE_URL

✗ process.env.DATABASE_URL || 'postgresql://...'

Server expects DATABASE_URL to be set; providing a fallback default is insecure and may lead to exposure.

mcpServers config

✓ {"mcpServers":{"crea-ddf":{"command":"npx","args":["-y","crea-ddf-mcp"],"env":{"DATABASE_URL":"..."}}}}

✗ {"mcpServers":{"crea-ddf":{"command":"crea-ddf-mcp","args":[],"environment":{"DATABASE_URL":"..."}}}}

Use 'env' not 'environment' in mcpServers; opencode uses 'environment' instead.

Shows minimal opencode configuration and a sample query workflow to list and describe database tables.

// In opencode config { "$schema": "https://opencode.ai/config.json", "mcp": { "crea-ddf": { "type": "local", "command": ["npx", "-y", "crea-ddf-mcp"], "environment": { "DATABASE_URL": "postgresql://user:password@localhost:5432/crea_ddf" }, "enabled": true } } } // After configuring, run: // opencode // Then ask agent: "List all tables and describe the 'properties' table" // The agent will call ddf_db_list_tables and ddf_db_describe_table

Debug

Known issues

gotchaDATABASE_URL must point to a database already synced by crea-ddf. The MCP server does not create or migrate tables.

fix

Run crea-ddf sync (from crea-ddf package) before using this server.

affects: >=0.0.0

gotchaopencode uses 'environment' while other MCP clients (e.g. Claude desktop) use 'env' in config. Using the wrong key results in connection failure.

fix

For opencode: use 'environment'. For other clients: use 'env'.

affects: >=0.0.0

gotcha'localhost' in DATABASE_URL refers to the client machine, not the database server if running in a container or remote. This can cause connection failures.

fix

Use a resolvable hostname or IP for the Postgres instance from the MCP client's perspective.

affects: >=0.0.0

breakingRequires Node.js >=24.14.0 (or bun >=1.3.0). Older Node versions will crash on startup.

fix

Update Node.js to >=24.14.0 or use bun >=1.3.0.

affects: >=0.0.0

Errors

Common errors & fixes

Error: connect ECONNREFUSED ::1:5432

DATABASE_URL points to localhost but Postgres is not running locally or is listening on a different interface.

fix

Ensure Postgres is running and accessible. Use the correct host (e.g., 127.0.0.1 or server IP).

Error: relation "properties" does not exist

Database has not been synced by crea-ddf or the connection is to a different database.

fix

Run crea-ddf sync first, or verify DATABASE_URL points to the correct database.

TypeError: Cannot read properties of undefined (reading 'connect')

DATABASE_URL environment variable is not set when starting the MCP server.

fix

Set DATABASE_URL in the environment or pass it via env/environment config.

Upgrade

Version history

0.0.4latest on npm

Audit

Dependencies

crea-ddfrequiredRequired for database schema and querying; must be pre-synced

Agent activity

26 hits · last 30 days

node

OpenAI (training)

Resources

githubhttps://github.com/WaryaWayne/crea-ddf-mcp ↗

packagecrea-ddf-mcp ↗

homepagehttps://github.com/WaryaWayne/crea-ddf-mcp ↗