{"_id":"@dici1435/db-mcp","name":"@dici1435/db-mcp","dist-tags":{"latest":"0.1.2"},"versions":{"0.1.2":{"name":"@dici1435/db-mcp","version":"0.1.2","description":"Database query and schema inspection MCP server for dici-spec projects.","type":"module","bin":{"dici-db-mcp":"dist/index.js"},"scripts":{"build":"esbuild src/index.ts --bundle --platform=node --target=node18 --format=esm --outfile=dist/index.js --banner:js=\"#!/usr/bin/env node\" --packages=external","dev":"tsx src/index.ts","test":"vitest run","test:watch":"vitest","typecheck":"tsc --noEmit","prepublishOnly":"npm run build"},"keywords":["mcp","database","postgresql","dici-spec"],"license":"MIT","engines":{"node":">=18"},"repository":{"type":"git","url":"git+https://github.com/MakerSoftware/dici-spec.git","directory":"mcp-servers/db"},"homepage":"https://github.com/MakerSoftware/dici-spec/tree/main/mcp-servers/db#readme","bugs":{"url":"https://github.com/MakerSoftware/dici-spec/issues"},"dependencies":{"@modelcontextprotocol/sdk":"^1.12.1","pg":"^8.13.3"},"devDependencies":{"@types/node":"^22.13.10","@types/pg":"^8.11.11","esbuild":"^0.25.1","tsx":"^4.19.3","typescript":"^5.8.2","vitest":"^4.1.0"},"_id":"@dici1435/db-mcp@0.1.2","_nodeVersion":"24.12.0","_npmVersion":"11.6.2","dist":{"integrity":"sha512-1ZdKhfUq6Y1mDlSkB/u36usRPJu4mBZEeThkGk6IgJPawd+58EGcjuq50Odcfza4j0CgRQ1vcZurjha+d4+RVQ==","shasum":"77027b9b59a65a6f952edfce0c83747396d8edab","tarball":"https://registry.npmjs.org/@dici1435/db-mcp/-/db-mcp-0.1.2.tgz","fileCount":3,"unpackedSize":20502,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCIQDCqxyLG5gK0FnfzIMwpaa+f5jVyD7RNOH1qfchIOFpNQIgG1pu4aRyewa+jfxaDF2JW79q3e9vl+QH7M7t+wRnmdo="}]},"_npmUser":{"name":"dici1433","email":"alex@maker.software"},"directories":{},"maintainers":[{"name":"dici1433","email":"alex@maker.software"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/db-mcp_0.1.2_1774043628315_0.27987097692436946"},"_hasShrinkwrap":false}},"time":{"created":"2026-03-20T21:53:48.245Z","0.1.2":"2026-03-20T21:53:48.465Z","modified":"2026-03-20T21:53:48.671Z"},"maintainers":[{"name":"dici1433","email":"alex@maker.software"}],"description":"Database query and schema inspection MCP server for dici-spec projects.","homepage":"https://github.com/MakerSoftware/dici-spec/tree/main/mcp-servers/db#readme","keywords":["mcp","database","postgresql","dici-spec"],"repository":{"type":"git","url":"git+https://github.com/MakerSoftware/dici-spec.git","directory":"mcp-servers/db"},"bugs":{"url":"https://github.com/MakerSoftware/dici-spec/issues"},"license":"MIT","readme":"# @dici1435/db-mcp\n\nDatabase query and schema inspection MCP server for dici-spec projects. Read-only PostgreSQL access for AI agents to inspect data and schema.\n\n## Installation\n\n```bash\nnpm install -g @dici1435/db-mcp\n# or run directly\nnpx @dici1435/db-mcp\n```\n\nTypically added to a project via `dici-spec add db`, which configures the MCP server and prompts for your database connection string.\n\n## Tools\n\n| Tool | Description |\n|---|---|\n| `db_query` | Execute a read-only SQL query (SELECT only). Mutations are rejected. Supports parameterized values. |\n| `db_describe_table` | Get full schema for a table: columns, types, nullability, defaults, indexes, foreign keys, constraints, row count |\n| `db_sample_rows` | Fetch sample rows (1-100) from a table for data exploration |\n| `db_compare_entity` | Compare a spec data-model entity against the actual DB schema. Reports drift: missing/extra columns, type mismatches |\n| `db_refresh_schema` | Refresh cached schema metadata for all tables. Use after running migrations. |\n\n## Environment Variables\n\n| Variable | Required | Default | Description |\n|---|---|---|---|\n| `DATABASE_URL` | **Yes** | — | PostgreSQL connection string (e.g. `postgresql://user:pass@localhost:5432/mydb`) |\n\n## Transport\n\nStdio (stdin/stdout). Designed to be launched by AI agent IDEs as a child process.\n\n## License\n\nMIT\n","readmeFilename":"README.md","_rev":"1-584fa8f2ca9c47c7d101065acbcb99fb"}