Mcp-dbutils

Features

- Enhance database configuration with SSL support
([22](https://github.com/donghao1393/mcp-dbutils/pull/22),
[`4ea4d0b`](https://github.com/donghao1393/mcp-dbutils/commit/4ea4d0b5deb51b8e9202839bd7a8cd5f71463c88))

* feat: enhance database configuration with SSL support

- Replace jdbc_url with url for better clarity - Add dedicated SSL configuration support - Update
documentation and examples - Update test cases

BREAKING CHANGE: Remove jdbc_url support as it was just added and not yet in production use

* docs: update documentation for SSL support and URL configuration

- Add SSL configuration examples - Update configuration format examples - Add configuration
documentation in both English and Chinese - Remove JDBC related content

Breaking Changes

- Remove jdbc_url support as it was just added and not yet in production use

Documentation

- Update README files to include new tools
([`eb796d5`](https://github.com/donghao1393/mcp-dbutils/commit/eb796d54ca517c173e26b8a535bfeb00545fbab0))

Added documentation for new tools: - dbutils-get-stats - dbutils-list-constraints -
dbutils-explain-query

Both English and Chinese READMEs updated

- Update README files with new monitoring tools
([18](https://github.com/donghao1393/mcp-dbutils/pull/18),
[`4b919fe`](https://github.com/donghao1393/mcp-dbutils/commit/4b919fe348e2f6ed35ea1f16b64a2706a5d875f4))

- Add dbutils-get-performance tool documentation - Add dbutils-analyze-query tool documentation -
Update both English and Chinese READMEs

- Update tool names with dbutils prefix
([`4731021`](https://github.com/donghao1393/mcp-dbutils/commit/4731021ab981ecca305414f34f72c1f8f0577b8e))

Renamed basic tools in README files: - list_tables -> dbutils-list-tables - query -> dbutils-query

Both English and Chinese READMEs updated

Features

- Add advanced database tools ([15](https://github.com/donghao1393/mcp-dbutils/pull/15),
[`2c85dc8`](https://github.com/donghao1393/mcp-dbutils/commit/2c85dc8c026bca93571ab8ed5b837518553087d5))

* Added three new tools:

1. dbutils-get-stats - Table statistics information - Column level statistics - Adapted for
PostgreSQL and SQLite

2. dbutils-list-constraints - Primary key, foreign key, unique constraints - Constraint definitions
and properties - Constraint comments support

3. dbutils-explain-query - EXPLAIN and EXPLAIN ANALYZE support - Detailed cost and timing estimates
- Database-specific optimizations

Implementation: - Added abstract methods to DatabaseHandler - Implemented in PostgreSQL and SQLite -
Added dedicated integration tests - Fixed SQL syntax and parameter issues

Refs 14

* fix: check non-SELECT statements in SQLite handler

- Add more database tools ([13](https://github.com/donghao1393/mcp-dbutils/pull/13),
[`8b8bd1e`](https://github.com/donghao1393/mcp-dbutils/commit/8b8bd1ea04d63e7828c81dc25a9c0cb70df73867))

* 添加更多数据库工具

添加三个新的数据库工具： - dbutils-describe-table：获取表的详细信息 - dbutils-get-ddl：获取表的DDL语句 -
dbutils-list-indexes：获取表的索引信息

实现内容： - DatabaseHandler新增三个抽象方法 - PostgreSQL和SQLite分别实现这些方法 - 添加新工具的集成测试 - 所有测试通过

Fixes 12

* test: 拆分表信息工具测试

将test_table_info_tools拆分为三个独立的测试函数： - test_describe_table_tool - test_get_ddl_tool -
test_list_indexes_tool

这样可以更清晰地展示每个工具的测试状态，便于定位问题。

- Enhance monitoring system with LLM dialog support
([17](https://github.com/donghao1393/mcp-dbutils/pull/17),
[`50d8df1`](https://github.com/donghao1393/mcp-dbutils/commit/50d8df1fabbf6513718582e6efe0d3832de9ce5d))

- Add query duration tracking - Add query type statistics - Add slow query detection - Add memory
usage tracking - Add performance statistics formatting - Add new MCP tools:
dbutils-get-performance and dbutils-analyze-query - Add tests for new features

Closes 16

Features

- Unify tool names with dbutils prefix ([11](https://github.com/donghao1393/mcp-dbutils/pull/11),
[`aa57995`](https://github.com/donghao1393/mcp-dbutils/commit/aa57995dc6cf3ffd33909162d831dffbbbf19bfc))

给工具名称添加dbutils前缀，使所有工具名称规范统一： - query -> dbutils-run-query - list_tables -> dbutils-list-tables

让工具名称更清晰地表明是属于dbutils的工具，避免与其他MCP服务的工具冲突。

Fixes 11

Documentation

- Update README with list_tables tool information
([`f3a2592`](https://github.com/donghao1393/mcp-dbutils/commit/f3a259200bbf18aaebbf6d4511a18d35246f5044))

Features

- Add database type prefix to list_tables tool response
([10](https://github.com/donghao1393/mcp-dbutils/pull/10),
[`e32ce1f`](https://github.com/donghao1393/mcp-dbutils/commit/e32ce1f2502f24d111643d7233f0fdd420238bd7))

添加数据库类型前缀到list_tables工具的返回结果中，使LLM能够知道当前操作的数据库类型， 便于后续操作。格式与错误信息保持一致，使用[数据库类型]前缀。

Fixes 9

Documentation

- Add SQLite JDBC URL configuration documentation
([6](https://github.com/donghao1393/mcp-dbutils/pull/6),
[`7d7ca8b`](https://github.com/donghao1393/mcp-dbutils/commit/7d7ca8bc7d4047a6c45dc3b8c6106e1fcbdd16d0))

- Add SQLite JDBC URL examples and explanation - Update configuration format description - Keep
Chinese and English documentation in sync

Part of 4

Features

- **tool**: Add list_tables tool for database exploration
([8](https://github.com/donghao1393/mcp-dbutils/pull/8),
[`6808c08`](https://github.com/donghao1393/mcp-dbutils/commit/6808c0868c8959450a9cfdcdf79a0af53bf22933))

* feat(tool): add list_tables tool for database exploration

This commit adds a new list_tables tool that allows LLMs to explore database tables without knowing
the specific database type, leveraging the existing get_tables abstraction.

Fixes 7

* test(tool): add integration tests for list_tables tool

* test: add integration tests for list_tables tool

This commit: - Adds test for list_tables tool functionality with both PostgreSQL and SQLite - Adds
test for error cases - Uses proper ClientSession setup for MCP testing

* fix(test): update test assertions for list_tables tool errors

- Fix incorrect error handling assertions - Fix indentation issues in test file - Use try-except
pattern for error testing

* fix(test): update error handling in list_tables tests

- Use MCP Error type instead of ConfigurationError - Fix indentation issues - Improve error
assertions

* fix(test): correct McpError import path

* fix(test): use correct import path for McpError

* fix(test): use try-except for error testing instead of pytest.raises

* test: skip unstable error test for list_tables tool

Documentation

- Add JDBC URL configuration documentation
([`a1b5f4b`](https://github.com/donghao1393/mcp-dbutils/commit/a1b5f4b424cec0df239bed65705aaac7c3e9072a))

- Add JDBC URL configuration examples to English and Chinese docs - Document secure credential
handling approach - Update configuration format descriptions

Part of feature 2

Features

- **config**: Add JDBC URL support for SQLite
([5](https://github.com/donghao1393/mcp-dbutils/pull/5),
[`9feb1e8`](https://github.com/donghao1393/mcp-dbutils/commit/9feb1e8c7e38a8e4e3c0f63c81a72f4a4edd05b5))

- Add JDBC URL parsing for SQLite configuration - Support SQLite specific URL format and parameters
- Keep credentials separate from URL - Complete test coverage for new functionality

Part of 4