v1.4.0

What's Changed

• Hotfix/stdio server by @linhdmn in #4

Full Changelog: v1.3.1...v1.4.0

v1.3.1

v1.3.1

Changes

• Create new execute file for linux

What's Changed

• Feat/multi database connection by @linhdmn in #2

Full Changelog: v1.3.0...v1.3.1

Release 25.03.2025

Database Model Context Protocol Server Release Notes

Version: v1.3.0
Release Date: 25th March 2025

Overview

We're excited to announce a major update to the Database Model Context Protocol Server. This release introduces robust support for connecting to multiple databases simultaneously, along with new database tools that provide a clear view of all connected databases. These enhancements are designed to streamline multi-database management and improve the overall user experience.

New Features

• Multiple Database Connections:
  Users can now establish and maintain simultaneous connections to multiple databases. This enhancement empowers you to work across diverse data sources within a single session, greatly improving flexibility and productivity.

• Enhanced Database Tools:
  The new DB tools now include a dedicated interface to display all connected databases. This feature offers:

  • Real-Time Monitoring: Instantly see which databases are connected.
  • Improved Navigation: Quickly switch between different database connections.
  • Detailed Connection Insights: Get information on each connected database to optimize your workflow.

Improvements

• Fix STDIO server to compatiple with Glama

• User Interface Enhancements:
  The dashboard has been updated to accommodate the new multi-database view, ensuring that connection statuses are clear and accessible.

• Performance Optimization:
  Streamlined the connection management processes to ensure minimal overhead when multiple databases are connected concurrently.

• Robust Error Handling:
  Added comprehensive error detection and handling mechanisms to improve stability when managing multiple database connections.

Getting Started

To take advantage of the new features, simply update your instance of the Database Model Context Protocol Server from our [GitHub repository](https://github.com/FreePeak/db-mcp-server). Detailed instructions for setting up multiple database connections and using the new DB tools can be found in our updated documentation.

Feedback

We welcome your feedback and suggestions. If you encounter any issues or have recommendations for further improvements, please open an issue on our GitHub page or contact our support team.

---

Thank you for using the Database Model Context Protocol Server. We look forward to seeing how these new features enhance your database management experience!

Feel free to adjust the version number, release date, or any other details as needed.

Release v1.2.1

DB MCP Server Release Notes

New Features

Visual SQL Query Builder

• Introducing the new dbQueryBuilder tool for constructing and validating SQL queries
• Supports validation to identify syntax errors before execution
• Build complex SQL queries through structured components:
  • SELECT statement with multiple column support
  • JOIN operations (inner, left, right, full)
  • WHERE conditions with various operators
  • GROUP BY and HAVING clauses
  • ORDER BY with sorting direction
  • LIMIT and OFFSET for pagination
• Query complexity analysis to identify potential performance issues
• Visual breakdown of query structure for easier understanding and modification

Database Performance Analyzer

• Added new dbPerformanceAnalyzer tool to identify and optimize slow queries
• Automatic tracking of query execution metrics:
  • Number of executions
  • Total, minimum, maximum, and average duration
  • Last executed timestamp
• Configurable thresholds for identifying slow queries
• Real-time detection and logging of performance issues
• Query analysis with optimization suggestions:
  • Detection of SELECT * usage
  • Identification of missing WHERE clauses
  • Recognition of JOIN conditions
  • Subquery optimization opportunities
• Support for normalizing queries to group similar patterns

Improvements

• Enhanced test suite to ensure reliability and accuracy
• Optimized performance monitoring with minimal impact on query execution
• Added asynchronous metrics collection for better performance

Database Schema Explore

Release Notes: Database Schema Explorer

Version 1.1.0

We're excited to announce the release of the Database Schema Explorer, a powerful new tool for the MCP Server that enables automatic discovery and exploration of your database structure and relationships.

New Features

• Auto-discovery of database schema without manual configuration
• Multiple exploration modes:
  • tables: List all tables with metadata (type, engine, row count, timestamps)
  • columns: Detailed information about columns in a specific table
  • relationships: Foreign key relationships between tables
  • full: Complete database schema with tables, columns, and relationships

Compatibility

• Full support for MySQL and PostgreSQL databases
• Smart fallback to simplified queries for compatibility with various database versions
• Graceful degradation to mock data when no database connection is available

Technical Improvements

• Proper handling of reserved SQL keywords for robust cross-database compatibility
• Integration with existing database connections and configuration
• Comprehensive error handling and detailed logging
• Support for query timeouts to prevent long-running operations

Usage

// Get all tables in the database
{"component": "tables"}

// Get columns for a specific table
{"component": "columns", "table": "users"}

// Get relationships for a specific table or all relationships
{"component": "relationships", "table": "orders"}
// or
{"component": "relationships"}

// Get the full database schema
{"component": "full"}

Benefits

• Rapid database exploration without writing SQL queries
• Improved development workflows with instant access to database structure
• Better understanding of database design and relationships
• Consistent schema information for both MySQL and PostgreSQL databases

This feature simplifies database interaction and provides valuable structural information for developers and tools using the MCP Server.

v1.0.2

Release v1.0.0

✨ Key Features

• Flexible Transport: Server-Sent Events (SSE) transport layer with robust connection handling
• Standard Messaging: JSON-RPC based message format for interoperability
• Dynamic Tool Registry: Register, discover, and invoke database tools at runtime
• Editor Integration: First-class support for VS Code and Cursor extensions
• Session Management: Sophisticated session tracking and persistence
• Structured Error Handling: Comprehensive error reporting for better debugging
• Performance Optimized: Designed for high throughput and low latency

Built-in Tools

The server currently includes three core database tools:

Tool	Description
dbQuery	Executes read-only SQL queries with parameterized inputs
dbExecute	Performs data modification operations (INSERT, UPDATE, DELETE)
dbTransaction	Manages SQL transactions with commit and rollback support