Mcp-dbutils

Features

- **config**: Add JDBC URL support for PostgreSQL
([3](https://github.com/donghao1393/mcp-dbutils/pull/3),
[`4f148f3`](https://github.com/donghao1393/mcp-dbutils/commit/4f148f31d5dc623b8b39201f0270d8f523e65238))

- Add JDBC URL parsing with strict security measures - Require credentials to be provided separately
- Implement validation for all required parameters - Add comprehensive test coverage

Closes 2

Bug Fixes

- Fix pkg_meta reference error in DatabaseServer
([`9bcc607`](https://github.com/donghao1393/mcp-dbutils/commit/9bcc607378df09fee8ef301c1ce0247f419c2dab))

- Move pkg_meta initialization before its usage - Add comment to clarify the purpose of pkg_meta -
Fix the variable reference error that caused server startup failure

- Fix prompts/list timeout by using correct decorator pattern
([`227f86d`](https://github.com/donghao1393/mcp-dbutils/commit/227f86db4c050439a382118df1bc62944f35aea4))

- Update Server initialization with version - Simplify list_prompts handler to return raw data - Add
comprehensive error handling in tests - Add debug logging for better traceability

- Unify logger naming across the project
([`088e60b`](https://github.com/donghao1393/mcp-dbutils/commit/088e60becb7112dc0a5da256b56d0f79ed1db223))

- Use package metadata for logger names - Add consistent naming hierarchy: - Root: mcp-dbutils -
Server: mcp-dbutils.server - Handler: mcp-dbutils.handler.<database> - Database:
mcp-dbutils.db.<type> - Remove hardcoded server names

- Unify prompts handler registration and remove duplicate init options
([`6031592`](https://github.com/donghao1393/mcp-dbutils/commit/60315922b052f252005ed77fd3978d8cff085056))

- Use package metadata for server name and version
([`7f48a6d`](https://github.com/donghao1393/mcp-dbutils/commit/7f48a6df50830d58c534495fc7bfc9198e9fbcc5))

- Replace hardcoded server name and version with values from pyproject.toml - Add importlib.metadata
to read package information - Ensure consistent versioning across the project

Build System

- Simplify semantic-release configuration
([`0f37153`](https://github.com/donghao1393/mcp-dbutils/commit/0f37153a0d7205238d0f43c16c97a390a3e368df))

- Remove __version__ variable reference - Change build command to use uv build - Keep version
management in pyproject.toml only

Code Style

- Unify log timestamp format with MCP framework
([`c341fb1`](https://github.com/donghao1393/mcp-dbutils/commit/c341fb1d05144c5c925fed25bfcd69be55ee7803))

- Use milliseconds precision in log timestamps to match MCP framework
([`2aae2fd`](https://github.com/donghao1393/mcp-dbutils/commit/2aae2fd06bf9b505105fd6b0671d70ba7dfef0f5))

Continuous Integration

- Add automatic release
([`b69e242`](https://github.com/donghao1393/mcp-dbutils/commit/b69e2429857824f0807eb76baccbbdf855c89e45))

- Add GitHub Actions workflow for automatic releases - Configure release triggers - Set up
permissions - Use python-semantic-release action

- Add uv installation to release workflow
([`62e0362`](https://github.com/donghao1393/mcp-dbutils/commit/62e036254cc1af6d1a1a3028838652365a528c53))

- Install uv before running semantic-release - Add uv binary to GitHub PATH - Ensure build command
can be executed

- Improve release workflow
([`07128a0`](https://github.com/donghao1393/mcp-dbutils/commit/07128a0ea7687963531e1aada24cc4083540272f))

- Separate version determination and build steps - Use actions/setup-python for Python environment -
Disable automatic build in semantic-release - Add manual build step using uv - Fix invalid action
parameters

- Improve release workflow reliability
([`4dac367`](https://github.com/donghao1393/mcp-dbutils/commit/4dac36749917b0d3fec94de5bcce1b5b0295e94f))

- Disable build in semantic-release - Add debug command to verify uv installation - Keep using uv
for package building - Ensure PATH is properly set

- Integrate PyPI publishing into release workflow
([`2ebd3f3`](https://github.com/donghao1393/mcp-dbutils/commit/2ebd3f327748fc78dd7e33e366517120260b3d3b))

- Add upload_to_pypi option to semantic-release action - Enable build in semantic-release - Remove
separate publish workflow - Simplify release process

- Update publish workflow trigger
([`26a6d79`](https://github.com/donghao1393/mcp-dbutils/commit/26a6d79eb8940cde6fb61ebe601754a1d8f22f0b))

- Add 'created' event type to release trigger - Support automatic PyPI publishing when
semantic-release creates a release - Keep 'published' event for manual releases

- Update release workflow for trusted publishing
([`8297cb8`](https://github.com/donghao1393/mcp-dbutils/commit/8297cb88b496c55d1f84355ed1a015ebf80a2c42))

- Add PyPI environment configuration - Use correct PyPI publish action version - Configure trusted
publishing permissions - Add PyPI project URL

Documentation

- Unify server name in configuration examples
([`5380898`](https://github.com/donghao1393/mcp-dbutils/commit/538089864e1cef72b0560ff369f30530f4358944))

- Change server name from 'dbutils' to 'mcp-dbutils' in all examples - Keep consistent with package
name and version in pyproject.toml - Update both English and Chinese documentation

Features

- Add database type to error messages
([`cf8d53b`](https://github.com/donghao1393/mcp-dbutils/commit/cf8d53baaee247fa6313ab6d0766144f9a3f0024))

- Add database type to query results
([`0cebfd9`](https://github.com/donghao1393/mcp-dbutils/commit/0cebfd99ffc9201c82a85d0b8e82ba59fa4a958e))

- Add version info to startup log
([`dc06741`](https://github.com/donghao1393/mcp-dbutils/commit/dc06741fce536884c1aeebd19838877c5901a546))

Chores

- Bump version to 0.2.11
([`96b023f`](https://github.com/donghao1393/mcp-dbutils/commit/96b023ff6bae3a643401b639c86403e7ac31df07))

Features

- Implement basic prompts support and list handler
([`397e71a`](https://github.com/donghao1393/mcp-dbutils/commit/397e71abca7286626c4eec4482e13ead83871e3a))

Documentation

- Update CHANGELOG for version 0.2.10
([`f3a6d4e`](https://github.com/donghao1393/mcp-dbutils/commit/f3a6d4ef0ce8c5fcbb0abf9b0b210447c40ce2c4))

Features

- Add resource monitoring system
([`f3ff859`](https://github.com/donghao1393/mcp-dbutils/commit/f3ff859a57c7bb046725a6ee9dd746e06bb488ff))

- Add ResourceStats for resource usage tracking - Improve database handlers using template method
pattern - Implement connection lifecycle monitoring - Add error pattern analysis - Output
monitoring data through stderr

Testing

- Add tests for resource monitoring system
([`ab9a644`](https://github.com/donghao1393/mcp-dbutils/commit/ab9a644bdae750831a9792bda157813eb9ab5ed1))

- Add unit tests for ResourceStats - Add integration tests for monitoring - Adjust base handler for
better testability

Bug Fixes

- Fix logger function calls
([`9b9fe45`](https://github.com/donghao1393/mcp-dbutils/commit/9b9fe45b60c74c7e14d7978b011f5c8b2399892d))

- Update logger calls to match create_logger function interface - Fix debug log calls in get_handler
method

- Fix logging and variable initialization
([`8f68320`](https://github.com/donghao1393/mcp-dbutils/commit/8f68320f13b7e5ca9bf6bb669a0212d0f705367b))

- Rename log to logger in DatabaseServer for consistency - Initialize handler variable before try
block to avoid UnboundLocalError - Fix logger reference in cleanup code

- Update handlers to use custom exceptions
([`02eb55c`](https://github.com/donghao1393/mcp-dbutils/commit/02eb55c8e4305043b09d8dc1ee4ece78a50c187c))

- Update PostgreSQL handler to use DatabaseError - Update SQLite handler to use DatabaseError - Add
specific error messages for non-SELECT queries - Improve error handling and logging

Documentation

- Update changelog for v0.2.9
([`0ccc28e`](https://github.com/donghao1393/mcp-dbutils/commit/0ccc28e926e54d7fad84f74dce36fcad75bfd7f0))

Features

- Optimize database type handling and error system
([`045b62d`](https://github.com/donghao1393/mcp-dbutils/commit/045b62d9a325304248252a86294766debc97590e))

- Remove redundant type detection based on path/dbname - Use explicit 'type' field from
configuration - Add custom exception hierarchy - Enhance logging system

Testing

- Update test cases for custom exceptions
([`93ef088`](https://github.com/donghao1393/mcp-dbutils/commit/93ef0889e00b37aaeedc83f4e3ba8debcb897100))

- Update test_postgres.py to use DatabaseError - Update test_sqlite.py to use DatabaseError - Fix
error message assertions for non-SELECT queries

Bug Fixes

- Properly remove all await on mcp_config
([`6153277`](https://github.com/donghao1393/mcp-dbutils/commit/6153277f06f404fbd8b8cd851f54024d706b4c05))

- Remove await on mcp_config in tests
([`e917226`](https://github.com/donghao1393/mcp-dbutils/commit/e917226b5dd23c6eb07200912e7d25f6c73135a2))

- Fix type error 'dict' object is not an async iterator - Update both postgres and sqlite tests -
Remove unnecessary awaits on mcp_config fixture

- Remove custom event_loop fixture
([`159f9e9`](https://github.com/donghao1393/mcp-dbutils/commit/159f9e9b86c7979061ffca3cf466ae81f642d67a))

- Remove custom event_loop fixture to use pytest-asyncio's default - Revert pyproject.toml changes
to minimize modifications - Fix pytest-asyncio deprecation warning

- Use pytest_asyncio.fixture for async fixtures
([`ea08512`](https://github.com/donghao1393/mcp-dbutils/commit/ea0851208b5c84331df50c6a1261acc24dbe7070))

- Replace pytest.fixture with pytest_asyncio.fixture for async fixtures - Keep original
pytest.fixture for non-async event_loop - Fix pytest-asyncio deprecation warnings

Chores

- Bump version to 0.2.8
([`d72cf52`](https://github.com/donghao1393/mcp-dbutils/commit/d72cf5272324cdb5164291b91139e537a07980db))

- Update version in pyproject.toml - Add 0.2.8 changelog entry for test improvements - Document
pytest-asyncio configuration changes

- Configure pytest-asyncio fixture loop scope
([`d8ca223`](https://github.com/donghao1393/mcp-dbutils/commit/d8ca22318609cff81fa2b1bd0a308cf97d3a7558))

- Set asyncio_mode to strict - Set asyncio_default_fixture_loop_scope to function - Fix
pytest-asyncio configuration warning

- Configure pytest-asyncio mode to auto
([`7898f61`](https://github.com/donghao1393/mcp-dbutils/commit/7898f61b960f74c4a3ca42366eb6004a6ca6d070))

- Add pytest config to remove asyncio warning - Set asyncio_mode to auto in tool.pytest.ini_options