{"name":"io.github.Idle-Sync/db-conn-mcp","slug":"idle-sync-db-conn-mcp","title":null,"description":"A dead-simple, self-hosted MCP server for securely querying databases via AI agents.","url":"https://mcp.market/server/idle-sync-db-conn-mcp","rating":null,"grade":"A","score":86,"certified":false,"status":"active","category":"other","tags":[],"presence":{"score":24,"stars":2,"forks":2,"downloads_week":74,"last_push_at":"2026-08-13T12:50:23.000Z","license":"MIT"},"uptime":null,"claimed":false,"transport":"pypi","callable_via_gateway":false,"default_price_micros":0,"repository":"https://github.com/Idle-Sync/db-conn-mcp","website":null,"version":"0.7.1","remotes":[],"packages":[{"registryType":"pypi","identifier":"db-conn-mcp","version":"0.7.1","transport":{"type":"stdio"}}],"tools":[{"name":"cancel_query","description":"Cancel the statement running in server backend `pid` (find pids via show_activity).","write_action":true,"price_micros":0,"input_schema":null},{"name":"check_database","description":"Test connectivity for one database (or all) — returns OK or a sanitized cause.","write_action":false,"price_micros":0,"input_schema":null},{"name":"check_sequences","description":"Find sequences lagging behind their column's max value (stale after migrations).","write_action":false,"price_micros":0,"input_schema":null},{"name":"close_cursor","description":"Close an open cursor and release its database connection. Idempotent.","write_action":false,"price_micros":0,"input_schema":null},{"name":"diff_schemas","description":"Compare the schemas of two configured databases (tables, columns, PK/FK).","write_action":false,"price_micros":0,"input_schema":null},{"name":"doctor","description":"Diagnose the whole setup, not just connectivity — use when something is misbehaving and check_database alone doesn't explain why.","write_action":false,"price_micros":0,"input_schema":null},{"name":"dump_schema_faithful","description":"Produce a byte-faithful schema dump using the database's own tool (pg_dump -s).","write_action":false,"price_micros":0,"input_schema":null},{"name":"execute_read_query","description":"Run a read-only SELECT query (enforced as a read-only transaction).","write_action":true,"price_micros":0,"input_schema":null},{"name":"execute_write_query","description":"Run an INSERT/UPDATE/DELETE/DDL statement on a write-mode database.","write_action":true,"price_micros":0,"input_schema":null},{"name":"explain_query","description":"Show the execution plan for a read-only query (EXPLAIN; optionally ANALYZE).","write_action":false,"price_micros":0,"input_schema":null},{"name":"fetch_rows","description":"Fetch the next N rows from an open cursor (see open_query_cursor).","write_action":false,"price_micros":0,"input_schema":null},{"name":"find_columns","description":"Find columns by name across all tables (fuzzy, case-insensitive substring).","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_database_schema","description":"Get the whole database's schema at once, as JSON or as a runnable SQL script.","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_object_definition","description":"Get the faithful SQL definition of a non-table object by name.","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_table_schema","description":"Get columns, types, and primary/foreign keys for a table.","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_databases","description":"List configured databases with their allowed mode and yolo flag (no DSN).","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_tables","description":"List all tables and views in the named database.","write_action":false,"price_micros":0,"input_schema":null},{"name":"open_query_cursor","description":"Open a server-side cursor over a read-only query for batched fetching.","write_action":false,"price_micros":0,"input_schema":null},{"name":"sample_table_rows","description":"Fetch the first N rows of a table to learn its data shape.","write_action":false,"price_micros":0,"input_schema":null},{"name":"search_value","description":"Find WHERE a value appears across tables (fuzzy, case-insensitive substring).","write_action":false,"price_micros":0,"input_schema":null},{"name":"set_yolo_mode","description":"Enable/disable yolo (skip the write-consent prompt) for one database, persisted.","write_action":false,"price_micros":0,"input_schema":null},{"name":"show_activity","description":"Show current server activity: pid, state, wait events, query/transaction age.","write_action":false,"price_micros":0,"input_schema":null},{"name":"table_stats","description":"Approximate row counts and disk/index sizes per table, largest first.","write_action":false,"price_micros":0,"input_schema":null}],"scan":{"score":86,"grade":"A","scanned_at":"2026-11-03T23:29:58.133Z","report":{"scannerVersion":"0.1.10","scannedAt":"2026-11-03T23:29:58.096Z","components":{"code":{"score":25,"max":25,"notes":["25 source files scanned"]},"reliability":{"score":-1,"max":20,"notes":["no gateway calls yet and no remote to probe"]},"poisoning":{"score":-1,"max":15,"notes":["tools not inspected (local package is not executed); not counted"]},"auth":{"score":12,"max":15,"notes":["local package, no credentials required"]},"maintenance":{"score":12,"max":15,"notes":["last push 82 days ago"]},"identity":{"score":7,"max":10,"notes":["registry namespace matches repository owner"]}},"findings":[],"inputs":{"packages":[{"registryType":"pypi","identifier":"db-conn-mcp","version":"0.7.1","found":true,"weeklyDownloads":74,"license":"MIT","dependencyCount":12,"publishedAt":"2026-08-13T12:51:14.313965Z","repositoryUrl":"https://github.com/Idle-Sync/db-conn-mcp"}],"repo":{"found":true,"owner":"Idle-Sync","repo":"db-conn-mcp","archived":false,"pushedAt":"2026-08-13T12:50:23Z","stars":2,"forks":2,"openIssues":15,"ownerType":"Organization","ownerAvatarUrl":"https://avatars.githubusercontent.com/u/260360050?v=4","ownerCreatedAt":"2026-02-09T06:32:26Z","license":"MIT"},"icon":{"url":null,"source":"none"},"presence":{"stars":2,"forks":2,"downloadsWeek":74,"license":"MIT","lastPushAt":"2026-08-13T12:50:23.000Z","score":24}}}},"grade_history":[],"reviews":[]}