Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| PUBMED_EMAIL | Yes | Your email address (required by NCBI) | |
| PUBMED_API_KEY | No | Optional API key for higher rate limits |
Schema
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| execute_query | Execute a SQL query on the connected SQL Server database |
| list_databases | List all databases on the SQL Server instance |
| list_tables | List all tables in a specific database |
| describe_table | Get the schema information for a specific table |
| list_foreign_keys | List all foreign key relationships in a schema |
| get_table_data | Get sample data from a table with optional filtering and limiting |
| export_table_csv | Export table data in CSV format |
| get_performance_stats | Get overall performance statistics and health summary |
| get_query_performance | Get detailed query performance breakdown by tool |
| get_connection_health | Get connection pool health metrics and diagnostics |
| explain_query | Get the execution plan for a SQL query to analyze performance |
| analyze_query_performance | Analyze query performance and provide optimization suggestions |
| get_index_recommendations | Get index recommendations for database optimization |
| detect_query_bottlenecks | Detect and analyze query bottlenecks in the database |
| get_optimization_insights | Get comprehensive database optimization insights and health analysis |
| get_server_info | Get MCP server configuration, status, and logging information |