aliyun/alibabacloud-hologres-mcp-server
Hologres MCP Server serves as a universal interface between AI Agents and Hologres databases. It enables seamless communication between AI Agents and Hologres, helping AI Agents retrieve Hologres database metadata and execute SQL operations.
uvx hologres-mcp-server{
"mcpServers": {
"hologres-mcp-server": {
"command": "uvx",
"args": [
"hologres-mcp-server"
],
"env": {
"HOLOGRES_HOST": "<HOLOGRES_HOST>",
"HOLOGRES_PORT": "<HOLOGRES_PORT>",
"HOLOGRES_USER": "<HOLOGRES_USER>",
"HOLOGRES_PASSWORD": "<HOLOGRES_PASSWORD>",
"HOLOGRES_DATABASE": "<HOLOGRES_DATABASE>"
}
}
}
}HOLOGRES_HOSTHOLOGRES_PORTHOLOGRES_USERHOLOGRES_PASSWORDHOLOGRES_DATABASEexecute_hg_select_sql
Execute a SELECT SQL query in Hologres database
execute_hg_select_sql_with_serverless
Execute a SELECT SQL query in Hologres database with serverless computing
execute_hg_dml_sql
Execute a DML (INSERT, UPDATE, DELETE) SQL query in Hologres database
execute_hg_ddl_sql
Execute a DDL (CREATE, ALTER, DROP, COMMENT ON) SQL query in Hologres database
gather_hg_table_statistics
Collect table statistics in Hologres database
get_hg_query_plan
Get query plan in Hologres database
get_hg_execution_plan
Get execution plan in Hologres database
call_hg_procedure
Invoke a procedure in Hologres database
create_hg_maxcompute_foreign_table
Create MaxCompute foreign tables in Hologres database.
list_hg_schemas
Lists all schemas in the current Hologres database, excluding system schemas.
list_hg_tables_in_a_schema
Lists all tables in a specific schema, including their types (table, view, external table, partitioned table).
show_hg_table_ddl
Show the DDL script of a table, view, or external table in the Hologres database.
query_and_plotly_chart
Execute a SELECT SQL query and generate a chart (bar, line, scatter, pie, histogram, area).
analyze_hg_query_by_id
Analyze a specific query's performance profile by its query_id from hg_query_log.
get_hg_slow_queries
Get slow queries from hg_query_log ordered by duration.
get_hg_dynamic_table_refresh_history
Get refresh history for a specific Dynamic Table, including duration, status, and latency.
restore_hg_table_from_recyclebin
Restore a dropped table from the Hologres recycle bin.
switch_hg_warehouse
Switch the current session's computing resource to a specified warehouse.
get_hg_table_storage_size
Get storage size details of a table, including total, data, index, and metadata breakdown.
cancel_hg_query
Cancel or terminate a running query by its process ID.
get_hg_table_properties
Get table properties including distribution_key, clustering_key, segment_key, bitmap_columns, binlog settings, etc.
get_hg_table_shard_info
Get table's Table Group and shard count info for diagnosing data skew.
get_hg_lock_diagnostics
Diagnose lock contention by showing blocking and waiting queries.
get_hg_table_info_trend
Get table storage trend from hg_table_info, showing daily storage size, file count, and row count changes.
manage_hg_query_queue
Create, drop, or clear a Query Queue.
manage_hg_classifier
Create or drop a classifier for a Query Queue.
set_hg_query_queue_property
Set or remove properties on a Query Queue or classifier.
manage_hg_warehouse
Manage a computing group: suspend, resume, restart, rename, or resize.
get_hg_warehouse_status
Get detailed running status and scaling progress of a computing group.
rebalance_hg_warehouse
Trigger shard rebalancing for a computing group to eliminate data skew.
query_hg_external_files
Query files directly from OSS using EXTERNAL_FILES function without creating foreign tables.
get_hg_guc_config
Get the current value of a GUC (Grand Unified Configuration) parameter.
Details on this page are taken from the project's README. Open README
supabase-community/supabase-mcp
The Model Context Protocol (MCP) standardizes how Large Language Models (LLMs) talk to external services like Supabase. It connects AI assistants directly with your Supabase project and allows them to perform tasks like managing tables, fetching config, and querying data. See the full list of tools.
googleapis/genai-toolbox
MCP Toolbox for Databases is an open source Model Context Protocol (MCP) server that connects your AI agents, IDEs, and applications directly to your enterprise databases.
alexander-zuev/supabase-mcp-server
Query MCP is an open-source MCP server that lets your IDE safely run SQL, manage schema changes, call the Supabase Management API, and use Auth Admin SDK — all with built-in safety controls.
MobinX/awesome-mcp-list
This is a continuously updated curated list of MCP servers, covering categories such as browser control, arts and culture, cloud platforms, command line, communication, customer data platforms, databases, developer tools, data science tools, file systems, finance and fintech, gaming, knowledge and memory, location services, marketing, monitoring, search and utilities. Each project includes a GitHub link and star count for quick reference and use.
stuzero/pg-mcp-server
PG-MCP is a server implementation of the Model Context Protocol for PostgreSQL databases. It provides a comprehensive API for AI agents to discover, connect to, query, and understand PostgreSQL databases through MCP's resource-oriented architecture.
bytebase/dbhub
[!NOTE] If you need an enterprise-level database MCP server with built-in guardrails like approval flow, access control, data masking, and audit logging beyond what DBHub offers, check out Bytebase.