Can this server support DESCRIBE?

[zhrt123]

When I used DESCRIBE with this server, I got the following error:

2025-04-02 17:01:57,599 - mcp.server.lowlevel.server - INFO - Processing request of type CallToolRequest
2025-04-02 17:01:57,599 - mysql_mcp_server - INFO - Calling tool: execute_sql with arguments: {'query': 'DESCRIBE t_device_management'}
2025-04-02 17:01:57,608 - mysql_mcp_server - ERROR - Error executing SQL 'DESCRIBE t_device_management': Unread result found

[designcomputer]

Thank you @zhrt123 for reporting this issue with the DESCRIBE command. I've confirmed the "Unread result found" error when using this command and have added it to our todo list for fixing.

In the meantime, you can use queries against the INFORMATION_SCHEMA database to get table structure information, which works correctly:

SELECT 
    COLUMN_NAME, 
    DATA_TYPE, 
    CHARACTER_MAXIMUM_LENGTH, 
    IS_NULLABLE, 
    COLUMN_DEFAULT, 
    COLUMN_COMMENT
FROM 
    INFORMATION_SCHEMA.COLUMNS 
WHERE 
    TABLE_SCHEMA = 'your_database_name' 
    AND TABLE_NAME = 't_device_management';

This actually provides even more detailed information than the DESCRIBE command. Thanks again for bringing this to our attention!