Note
Datafy is deeply rooted in and built upon DBHub. Their documentation and implementation remain a highly relevant foundation.
____ _ __
| _ \ __ _| |_ __ _ / _|_ _
| | | |/ _` | __/ _` | |_| | | |
| |_| | (_| | || (_| | _| |_| |
|____/ \__,_|\__\__,_|_| \__, |
|___/
+------------------+ +--------------+ +------------------+
| | | | | |
| | | | | |
| Claude Desktop +--->+ +--->+ PostgreSQL |
| | | | | |
| Claude Code +--->+ +--->+ SQL Server |
| | | | | |
| Cursor +--->+ Datafy +--->+ SQLite |
| | | | | |
| VS Code +--->+ +--->+ MySQL/MariaDB |
| | | | | |
| Copilot CLI +--->+ +--->+ Redis |
| | | | | |
| | | +--->+ Elasticsearch |
| | | | | |
+------------------+ +--------------+ +------------------+
MCP Clients MCP Server DatabasesDatafy is a zero-dependency, token efficient MCP server implementing the Model Context Protocol (MCP) server interface. This lightweight gateway allows MCP-compatible clients to connect to and explore different databases:
- Local Development First: Zero dependency, token efficient with just two MCP tools to maximize context window
- Multi-Database: PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, Redis, and Elasticsearch through a single interface
- Multi-Connection: Connect to multiple databases simultaneously with TOML configuration
- Guardrails: Read-only mode, row limiting, and query timeout to prevent runaway operations
- Secure Access: SSH tunneling and SSL/TLS encryption
PostgreSQL, MySQL, SQL Server, MariaDB, SQLite, Redis, and Elasticsearch.
Datafy implements MCP tools for database operations:
- execute_sql: Execute SQL queries with transaction support and safety controls
- search_objects: Search and explore database schemas, tables, columns, indexes, and procedures with progressive disclosure
- redis_command: Execute Redis commands (e.g., GET, SET, HGETALL) directly
- elasticsearch_search: Execute Elasticsearch queries using JSON DSL or simplified syntax
- Custom Tools: Define reusable, parameterized SQL operations in your
dbhub.tomlconfiguration file
See the full Installation Guide for detailed instructions.
Docker:
docker run --rm --init \
--name datafy \
--publish 8080:8080 \
teckedd-code2save/datafy \
--transport http \
--port 8080 \
--dsn "postgres://user:password@localhost:5432/dbname?sslmode=disable"NPM:
npx @teckedd-code2save/datafy@latest --transport http --port 8080 --dsn "postgres://user:password@localhost:5432/dbname?sslmode=disable"Demo Mode:
npx @teckedd-code2save/datafy@latest --transport http --port 8080 --demoSee Command-Line Options for all available parameters.
Connect to multiple databases simultaneously using TOML configuration files. Perfect for managing production, staging, and development databases from a single Datafy instance.
See Multi-Database Configuration for complete setup instructions.
# Install dependencies
pnpm install
# Run in development mode
pnpm dev
# Build and run for production
pnpm build && pnpm start --transport stdio --dsn "postgres://user:password@localhost:5432/dbname"