Warp SQL Server MCP
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 |
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| execute_queryC | Execute a SQL query on the connected SQL Server database |
| list_databasesA | List all databases on the SQL Server instance |
| list_tablesB | List all tables in a specific database |
| describe_tableC | Get the schema information for a specific table |
| list_foreign_keysC | List all foreign key relationships in a schema |
| get_table_dataC | Get sample data from a table with optional filtering and limiting |
| export_table_csvC | Export table data in CSV format |
| get_performance_statsB | Get overall performance statistics and health summary |
| get_query_performanceC | Get detailed query performance breakdown by tool |
| get_connection_healthB | Get connection pool health metrics and diagnostics |
| explain_queryC | Get the execution plan for a SQL query to analyze performance |
| analyze_query_performanceC | Analyze query performance and provide optimization suggestions |
| get_index_recommendationsC | Get index recommendations for database optimization |
| detect_query_bottlenecksC | Detect and analyze query bottlenecks in the database |
| get_optimization_insightsC | Get comprehensive database optimization insights and health analysis |
| get_server_infoC | Get MCP server configuration, status, and logging information |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/egarcia74/warp-sql-server-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server