Mcp-dbutils

Bug Fixes

- Add venv creation in CI workflow
([`386faec`](https://github.com/donghao1393/mcp-dbutils/commit/386faec3213a7cd4ce7e14a43225f005f3f28702))

- Update coverage badge configuration
([`c6bc9bd`](https://github.com/donghao1393/mcp-dbutils/commit/c6bc9bdee4006fc8dd2d3e4dcf9111ce4ad104b0))

- Update to dynamic-badges-action v1.7.0 - Ensure integer percentage value - Add proper quotes to
parameters

Features

- Add coverage badge to README
([`20435d8`](https://github.com/donghao1393/mcp-dbutils/commit/20435d87c657413d656cf61abb5e16bcf6fc0300))

- Added coverage badge generation in CI workflow - Added coverage badge to README - Updated
CHANGELOG.md

- Add Github Actions workflow for automated testing
([`355a863`](https://github.com/donghao1393/mcp-dbutils/commit/355a863193ead9d21d928c21453e64c67e71d760))

- Added GitHub Actions workflow for test automation - Added PostgreSQL service in CI environment -
Added detailed test and coverage reporting - Bump version to 0.2.7

Features

- Add test coverage reporting
([`93fe2f7`](https://github.com/donghao1393/mcp-dbutils/commit/93fe2f73dc472c8e8b5e7eb0a1b65879c806aa8a))

- Added pytest-cov for test coverage tracking - Added .coveragerc configuration - HTML coverage
report generation - Updated .gitignore for coverage files - Updated CHANGELOG.md - Bump version to
0.2.6

Documentation

- Enhance Docker documentation with database connection details
([`af42c97`](https://github.com/donghao1393/mcp-dbutils/commit/af42c97259eb9a5f5f2d135f8bac9690029fa843))

- Add examples for SQLite database file mapping - Document host PostgreSQL connection from container
- Provide configuration examples for different OS environments - Add notes about
host.docker.internal and network settings

- Show real-time chart on readme
([`704e5fd`](https://github.com/donghao1393/mcp-dbutils/commit/704e5fde808b996f00b51c1f534073e262c94384))

- Update changelog for v0.2.5
([`cb71c83`](https://github.com/donghao1393/mcp-dbutils/commit/cb71c831193c7b0758592075271d90ff48b00c94))

Features

- Add initial automated tests
([`935a77b`](https://github.com/donghao1393/mcp-dbutils/commit/935a77b0d5076fe141a92128eeabc249ff3489c8))

- Add integration tests for PostgreSQL and SQLite handlers: * Table listing and schema querying *
SELECT query execution and result formatting * Non-SELECT query rejection * Error handling for
invalid queries - Configure test fixtures and environments in conftest.py - Set up pytest
configurations in pyproject.toml - Update .gitignore to exclude memory-bank folder for cline

Tests verify core functionality while adhering to read-only requirements.

Documentation

- Major documentation improvements and version 0.2.4
([`7a9404a`](https://github.com/donghao1393/mcp-dbutils/commit/7a9404ad513d4b1f65f9c74f6a3eac0ea43058c9))

- Unified server configuration name to "dbutils" - Added architecture diagrams in both English and
Chinese - Enhanced installation instructions with environment variables - Added contributing
guidelines - Added acknowledgments section - Updated badges and improved formatting - Bump version
to 0.2.4

Bug Fixes

- Remove uv cache dependency in GitHub Actions
([`a68f32e`](https://github.com/donghao1393/mcp-dbutils/commit/a68f32e5515ca6b6253442d74a5b9112e7ebf852))

- Remove cache-dependency-glob parameter - Disable uv cache to avoid dependency on uv.lock file

Chores

- Bump version to 0.2.3
([`771e01e`](https://github.com/donghao1393/mcp-dbutils/commit/771e01efcf8ecb32c85b133836d5f179a0f2ce08))

- Update version in pyproject.toml - Add version 0.2.3 to CHANGELOG.md - Document installation
guides, internationalization, and CI/CD additions

Continuous Integration

- Add PyPI publishing workflow
([`ae5f334`](https://github.com/donghao1393/mcp-dbutils/commit/ae5f334190091207302a258311172804fd25ac16))

- Create .github/workflows/publish.yml - Configure uv environment using astral-sh/setup-uvv4 - Set
up automatic build and PyPI publishing - Enable trusted publishing mechanism

Documentation

- Add MIT license and update project metadata
([`f98e656`](https://github.com/donghao1393/mcp-dbutils/commit/f98e656804d279bb53e193bfa87bfd1cd240e0db))

- Update installation guide and add English README
([`a4e60e0`](https://github.com/donghao1393/mcp-dbutils/commit/a4e60e0e792e34a4f327fe8a49e1a24a430b2abb))

- Add installation methods (uvx/pip/docker) - Update configuration examples for each installation
method - Create English README with badges - Update project name to mcp-dbutils - Add
cross-references between Chinese and English docs

- Update version to 0.2.2 and add CHANGELOG
([`381c69b`](https://github.com/donghao1393/mcp-dbutils/commit/381c69bf31af5f58d96f871de0088214cc77ca48))

- 添加中文readme文档
([`a3737b9`](https://github.com/donghao1393/mcp-dbutils/commit/a3737b995857b414c5ba40f1958f2b7b9b2aa65d))

- 添加README_CN.md详细说明项目功能和使用方法 - 重点解释抽象层设计理念和架构 - 包含配置示例和使用示范 - 提供完整的API文档

Bug Fixes

- Add missing Path import in sqlite server
([`fb35c1a`](https://github.com/donghao1393/mcp-dbutils/commit/fb35c1a56531456ca27319922b20efe14381b38d))

- Add pathlib import for Path usage in SQLite server - Fix code formatting

- Automatic database type detection from config
([`9b69882`](https://github.com/donghao1393/mcp-dbutils/commit/9b698824acc721cd697325ff0c601e11cd68ef33))

- Remove --type argument and detect db type from config - Unify configuration handling for both
postgres and sqlite - Detect db type based on config parameters - Update SqliteServer to match
PostgresServer interface

Features

- Add explicit database type declaration and awareness
([`2d47804`](https://github.com/donghao1393/mcp-dbutils/commit/2d47804ca917e2f59b0832a7a6c92789fc97f0b8))

1. Add required 'type' field to configs to explicitly declare database type 2. Standardize field
naming, rename 'db_path' to 'path' 3. Include database type and config name in query results 4.
Restructure response format to unify normal results and error messages

This change enables LLMs to be aware of the database type in use, allowing them to auto-correct when
incorrect SQL syntax is detected.

- Add password support for sqlite databases
([`537f1dc`](https://github.com/donghao1393/mcp-dbutils/commit/537f1dc96291ed57dbe7a52c9c7a80a868270152))

- Support password-protected SQLite databases in config - Use URI connection string for SQLite with
password - Update connection handling and parameter passing - Add password masking in logs

- Remove required --database argument and enhance logging
([`9b49ac7`](https://github.com/donghao1393/mcp-dbutils/commit/9b49ac70e88a8c1d0469cdb36ae8608fd01ccaaa))

- Remove mandatory --database argument - Add connection status monitoring for all databases - Add
automatic retry mechanism with configurable interval - Add MCP_DB_RETRY_INTERVAL environment
variable (default: 1800s) - Add proper MCP_DEBUG support - Remove duplicated code - Improve
logging for connection status changes

- Standardize logging
([`df264b5`](https://github.com/donghao1393/mcp-dbutils/commit/df264b55aed6341778f860e05072306cbb24388d))

- Use standardized logging mechanism from log.py

- **sqlite**: Add support for dynamic database switching
([`3f71de0`](https://github.com/donghao1393/mcp-dbutils/commit/3f71de0d220eca8252f325b264ccaa401fd71646))

- Add config_path parameter to SQLite server initialization - Add optional database parameter to
query tool - Implement dynamic database switching in call_tool method - Keep interface consistent
with PostgreSQL server

Refactoring

- Redesign database server architecture for dynamic database switching
([`7f0a7b9`](https://github.com/donghao1393/mcp-dbutils/commit/7f0a7b92561baf357b67aa5596b6842659a934bb))

- Add DatabaseHandler base class for individual database connections - Move database operations from
server to handlers - Implement on-demand database handler creation and cleanup - Simplify server
initialization and configuration - Make database parameter required in query tool - Remove the
remaining mcp_postgres directories and files

- Remove default database connection behavior
([`45fe01c`](https://github.com/donghao1393/mcp-dbutils/commit/45fe01c1ae27cde43843e410c45826565a18fe50))

- Remove default database concept from base implementation - Require explicit database specification
for all operations - Convert PostgreSQL handler from connection pool to per-operation connections
- Remove immediate connection testing in handlers - Fix resource cleanup in PostgreSQL handler