{"id":40804,"library":"database-mcp","title":"Database MCP Server","description":"A Model Context Protocol (MCP) server that provides AI assistants with direct access to PostgreSQL, MySQL, SQLite, and Snowflake databases. Version 1.3.2 (stable, active development) enables natural language interactions through comprehensive introspection and analysis tools. Key differentiators: multi-database support with a unified interface, automatic SSL/TLS handling for cloud databases, read-only safe query execution, and CLI tools for quick setup with Claude Desktop. Ships TypeScript types. Release cadence: frequent minor releases.","status":"active","version":"1.3.2","language":"javascript","source_language":"en","source_url":"https://github.com/nitaiaharoni1/database-mcp","tags":["javascript","mcp","model-context-protocol","npx","postgresql","postgres","mysql","sqlite","snowflake","typescript"],"install":[{"cmd":"npm install database-mcp","lang":"bash","label":"npm"},{"cmd":"yarn add database-mcp","lang":"bash","label":"yarn"},{"cmd":"pnpm add database-mcp","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"MCP server framework dependency","package":"@modelcontextprotocol/sdk","optional":false},{"reason":"PostgreSQL client driver","package":"pg","optional":true},{"reason":"MySQL client driver","package":"mysql2","optional":true},{"reason":"SQLite client driver","package":"better-sqlite3","optional":true},{"reason":"Snowflake client driver","package":"snowflake-sdk","optional":true}],"imports":[{"note":"ESM-only package. CommonJS require is not supported.","wrong":"const DatabaseMCPServer = require('database-mcp')","symbol":"DatabaseMCPServer","correct":"import { DatabaseMCPServer } from 'database-mcp'"},{"note":"Named export, not default export.","wrong":"import createServer from 'database-mcp'","symbol":"createServer","correct":"import { createServer } from 'database-mcp'"}],"quickstart":{"code":"npx database-mcp init \"postgresql://user:pass@localhost:5432/mydb\"\nnpx database-mcp status","lang":"javascript","description":"Initializes the MCP server with a PostgreSQL connection string and verifies status using the CLI."},"warnings":[{"fix":"Use `database-mcp init <connection-string>` instead.","message":"The --setup and --configure flags are deprecated in favor of the init command.","severity":"deprecated","affected_versions":">=1.2.4"},{"fix":"Use ES module imports or dynamic import() in CommonJS projects.","message":"The package is ESM-only and cannot be used with CommonJS require().","severity":"gotcha","affected_versions":">=1.0.0"},{"fix":"Use `import { DatabaseMCPServer } from 'database-mcp'` instead of default import.","message":"Version 1.2.0 changed the default export to a named export.","severity":"breaking","affected_versions":">=1.2.0 <1.2.4"},{"fix":"No workaround; design is intentional for safety.","message":"The server runs read-only queries by default; write operations are blocked.","severity":"gotcha","affected_versions":">=1.0.0"}],"env_vars":null,"search_vec":"'1.3.2':25 'access':16 'activ':27 'ai':12 'analysi':37 'assist':13 'automat':49 'cadenc':74 'claud':68 'cli':62 'cloud':53 'comprehens':34 'context':6,82 'databas':1,23,43,54 'desktop':69 'develop':28 'differenti':40 'direct':15 'enabl':29 'execut':60 'frequent':75 'handl':51 'interact':32 'interfac':48 'introspect':35 'javascript':78 'key':39 'languag':31 'mcp':2,8,79 'minor':76 'model':5,81 'model-context-protocol':80 'multi':42 'multi-databas':41 'mysql':19,87 'natur':30 'npx':84 'postgr':86 'postgresql':18,85 'protocol':7,83 'provid':11 'queri':59 'quick':65 'read':56 'read-on':55 'releas':73,77 'safe':58 'server':3,9 'setup':66 'ship':70 'snowflak':22,89 'sqlite':20,88 'ssl/tls':50 'stabl':26 'support':44 'tool':38,63 'type':72 'typescript':71,90 'unifi':47 'version':24","created_at":"2026-06-04T18:49:20.873347+00:00","updated_at":"2026-06-04T18:49:20.873347+00:00","problems":[{"fix":"Run `npm install database-mcp` and ensure you are using ES module imports.","cause":"Package not installed or wrong import path.","error":"Cannot find module 'database-mcp'"},{"fix":"Use dynamic import: `const DatabaseMCPServer = await import('database-mcp')`","cause":"Using CommonJS require() on an ESM-only package.","error":"ERR_REQUIRE_ESM"},{"fix":"Use `database-mcp init <connection-string>`","cause":"Using deprecated CLI flags.","error":"database-mcp: --setup is deprecated, use init instead"}],"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":"https://github.com/nitaiaharoni1/database-mcp#readme","github":"https://github.com/nitaiaharoni1/database-mcp","docs":null,"changelog":null,"pypi":null,"npm":"database-mcp","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-04","next_check":"2026-09-02","install_tag":null}}