DB-MCP-Server provides a database connectivity layer for AI assistants through the Model Context Protocol, enabling direct interaction with MySQL and PostgreSQL databases. Built in Go, it supports both local stdio and production SSE transport modes, with configurable database connections through environment variables. The server can be deployed using Docker for easy integration into existing workflows, making it ideal for AI applications that need to query, analyze, or manipulate structured data stored in relational databases without requiring separate database access tools.
Nessuna recensione ancora. Sii il primo a recensire!
Accedi per unirti alla conversazione
Highlight AIExecute SELECT queries and get results as a tabular dataset.
Run data manipulation statements (INSERT, UPDATE, DELETE).
Begin, commit, and rollback transactions.
Get information about tables, columns, indexes, and foreign keys.
Generate SQL or code from database schema.
Analyze query performance and get optimization suggestions.
Perform general TimescaleDB operations.
Convert a standard table to a TimescaleDB hypertable.
List all hypertables in the database.
Execute optimized time-series queries with bucketing.
Analyze time-series data patterns.
Create materialized views that automatically update.
Manually refresh continuous aggregates.