DBchat
Verified Safeby skanga
Overview
Transforms a database into an intelligent conversational partner, enabling natural language queries, instant answers, and data visualizations via MCP clients.
Installation
java -jar dbchat-4.1.0.jar --http_mode=true --http_port=8080Environment Variables
- DB_URL
- DB_DRIVER
- DB_USER
- DB_PASSWORD
- HTTP_MODE
- BIND_ADDRESS
- HTTP_PORT
- MAX_CONNECTIONS
- CONNECTION_TIMEOUT_MS
- IDLE_TIMEOUT_MS
- MAX_LIFETIME_MS
- LEAK_DETECTION_THRESHOLD_MS
- QUERY_TIMEOUT_SECONDS
- SELECT_ONLY
- MAX_SQL
- MAX_ROWS_LIMIT
Security Notes
The server implements extensive security measures: input sanitization (SecurityUtils) for values and identifiers, strict query validation in 'selectOnly' mode blocking DDL/DML, parameterized query support (PreparedStatement) to prevent SQL injection, enforcement of max SQL length and max rows limits, and robust security warnings in all responses to clients. It logs critical security events for auditing. While CORS 'Access-Control-Allow-Origin: *' is set by default for local client integration, which is acceptable for a local MCP server, it would be a vulnerability in a public-facing deployment.
Similar Servers
nlp2sql
Converting natural language queries to optimized SQL for enterprise databases using multiple AI providers.
database-ontology-mcp
Analyzes relational database schemas, generates semantic ontologies (RDF/OWL, R2RML), and provides tools for Text-to-SQL convenience, secure query execution, and data visualization.
DatabaseMcpServer
Provides a robust and secure database access layer for AI assistants, supporting 19 types of databases with single-instance multi-database dynamic switching and over 50 tools for data and schema management.
mcp-server-generator
Generate Model Context Protocol (MCP) servers from database datasources for integration with AI agents, using a visual canvas interface for tool creation and management.