{"id":43669,"library":"postgres-mcp-runner","title":"Postgres MCP Runner","description":"Node.js-based Postgres Model Context Protocol (MCP) worker application. Current stable version is 1.0.7. Release cadence is not specified. Key differentiator: it serves as a Postgres MCP worker running in Streamable HTTP mode, enabling AI agents to interact with PostgreSQL databases via the MCP protocol. It is published on npm for easy integration.","status":"active","version":"1.0.7","language":"javascript","source_language":"en","source_url":null,"tags":["javascript"],"install":[{"cmd":"npm install postgres-mcp-runner","lang":"bash","label":"npm"},{"cmd":"yarn add postgres-mcp-runner","lang":"bash","label":"yarn"},{"cmd":"pnpm add postgres-mcp-runner","lang":"bash","label":"pnpm"}],"dependencies":[],"imports":[{"note":"ESM module; require() may not work without transpilation.","wrong":"const postgresMcpRunner = require('postgres-mcp-runner')","symbol":"default","correct":"import postgresMcpRunner from 'postgres-mcp-runner'"},{"note":"Named export; use ESM import for consistency.","wrong":"const { PostgresMcpRunner } = require('postgres-mcp-runner')","symbol":"PostgresMcpRunner","correct":"import { PostgresMcpRunner } from 'postgres-mcp-runner'"},{"note":"Utility function to start the MCP worker.","wrong":null,"symbol":"runWorker","correct":"import { runWorker } from 'postgres-mcp-runner'"}],"quickstart":{"code":"npm install\nnpm run build\nnode main.js","lang":"javascript","description":"Shows how to install dependencies, build the project, and run the Postgres MCP worker locally."},"warnings":[{"fix":"Ensure you are using the correct package and check the README.","message":"The package name 'postgres-mcp-runner' may be confused with other MCP-related packages.","severity":"gotcha","affected_versions":">=1.0.0"},{"fix":"Monitor changelog for updates.","message":"Deprecated: The package may have breaking changes in future versions.","severity":"deprecated","affected_versions":">=1.0.0"},{"fix":"Use 'node main.js' instead of 'node index.js'.","message":"Breaking: The main entry point changed from index.js to main.js in version 1.0.0.","severity":"breaking","affected_versions":">=1.0.0"},{"fix":"Set POSTGRES_HOST, POSTGRES_PORT, POSTGRES_USER, POSTGRES_PASSWORD, POSTGRES_DB.","message":"Environment variables for database connection must be set before running.","severity":"gotcha","affected_versions":">=1.0.0"},{"fix":"Use nvm to switch to Node 18+.","message":"The application requires Node.js version 18 or higher.","severity":"gotcha","affected_versions":">=1.0.0"},{"fix":"Watch for updates in the README.","message":"The 'npm run build' step may be removed in future versions; consider using a prebuilt binary.","severity":"deprecated","affected_versions":">=1.0.0"}],"env_vars":null,"search_vec":"'1.0.7':17 'agent':39 'ai':38 'applic':12 'base':5 'cadenc':19 'context':8 'current':13 'databas':44 'differenti':24 'easi':55 'enabl':37 'http':35 'integr':56 'interact':41 'javascript':57 'key':23 'mcp':2,10,30,47 'mode':36 'model':7 'node.js':4 'npm':53 'postgr':1,6,29 'postgresql':43 'protocol':9,48 'publish':51 'releas':18 'run':32 'runner':3 'serv':26 'specifi':22 'stabl':14 'streamabl':34 'version':15 'via':45 'worker':11,31","created_at":"2026-06-05T17:00:54.597514+00:00","updated_at":"2026-06-05T17:00:54.597514+00:00","problems":[{"fix":"Run 'npm install postgres-mcp-runner'.","cause":"Package not installed or not in node_modules.","error":"Cannot find module 'postgres-mcp-runner'"},{"fix":"Set PORT environment variable to a different port, e.g., PORT=3001 node main.js.","cause":"Default port 3000 is already in use.","error":"Error: listen EADDRINUSE :::3000"},{"fix":"Use 'import postgresMcpRunner from \"postgres-mcp-runner\"' or enable ESM in package.json.","cause":"Importing the module incorrectly (e.g., using require on an ESM default export).","error":"TypeError: postgresMcpRunner is not a function"},{"fix":"Verify PostgreSQL is running and environment variables are set correctly.","cause":"PostgreSQL server is not running or connection parameters are incorrect.","error":"Error: Connect to PostgreSQL failed: Connection refused"}],"ecosystem":"npm","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":null,"github":null,"docs":null,"changelog":null,"pypi":null,"npm":"postgres-mcp-runner","openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-05","next_check":"2026-09-03","install_tag":null}}