README.md
A secure Model Context Protocol implementation to query PostgreSQL databases.
A secure Model Context Protocol implementation that enables AI agents to query PostgreSQL databases through predefined tools for employee, project, and issue data. It protects sensitive credentials and prevents arbitrary SQL execution by acting as a controlled connector layer between the LLM and the database.
Tools (3)
query_employeesQuery employee data from the database using predefined filters.query_projectsRetrieve project information and status updates.query_issuesFetch issue tracking data related to specific projects.Environment Variables
DATABASE_URLrequiredPostgreSQL connection string including credentials and host.Configuration
claude_desktop_config.json
{"mcpServers":{"mcp-dummy-db":{"command":"npx","args":["-y","@muniasamyk/mcp-project"],"env":{"DATABASE_URL":"postgresql://user:password@localhost:5432/dbname"}}}}Try it
→List all employees currently working in the Engineering department.
→Show me all active projects managed by employee ID 101.
→Find all high-priority issues associated with the 'Alpha' project.
→Get a summary of project statuses from the database.