{"repo":"srthkdev/omnisql-mcp","free":true,"listed":false,"github":"https://github.com/srthkdev/omnisql-mcp","clone":"git clone https://github.com/srthkdev/omnisql-mcp.git","description":"omnisql-mcp","language":"TypeScript","stars":74,"topics":["claude-ai","database","mcp-servers"],"license":"MIT","category":"mcp-servers","readme_excerpt":"OmniSQL MCP Universal database MCP server — give AI assistants read/write access to your databases using connections already saved in your local DB client workspace (DBeaver-compatible). Database Support Natively supported (direct driver, fast): - PostgreSQL (via pg ) - MySQL / MariaDB (via mysql2 ) - SQL Server / MSSQL (via mssql ) - SQLite (via sqlite3 CLI) Postgres-compatible (routed through pg driver automatically): - CockroachDB, TimescaleDB, Amazon Redshift, YugabyteDB, AlloyDB, Supabase, Neon, Citus Other databases : Fall back to an external CLI configured via OMNISQL CLI PATH . Results vary by CLI. Features - Reuses connections already configured in your local DB client workspace — no duplicate setup - Native query execution for PostgreSQL, MySQL/MariaDB, SQLite, SQL Server - Connection pooling with configurable pool size and timeouts - Transaction support (BEGIN/COMMIT/ROLLBACK) - Query execution plan analysis (EXPLAIN) - Schema comparison between connections with migration script generation - Read-only mode with enforced SELECT-only on execute query - Connection whitelist to restrict which databases are accessible - Tool filtering to disable specific operations - Query validation to block dangerous operations (DROP DATABASE, TRUNCATE, DELETE/UPDATE without WHERE) - Data export to CSV/JSON - Graceful shutdown with connection pool cleanup Requirements - Node.js 18+ - A local DB client (DBeaver-compatible) with at least one configured connection Installation Configurat","default_branch":null,"files":null,"tree":[],"storefront":"/r/srthkdev","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/srthkdev/omnisql-mcp/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}