{"slug":"madhukarkumar/singlestore-mcp-server","name":"SingleStore MCP Server","description":"An MCP server for interacting with SingleStore databases, requiring environment variables for connection.","category":"database","tags":[],"official":false,"stars":4,"transport":"stdio","install":[{"cmd":"npx -y @smithery/cli","imports":[]}],"tools":[{"name":"list_tables","description":"Lists all tables in the database"},{"name":"query_table","description":"Executes a custom SQL query"},{"name":"describe_table","description":"Gets detailed information about a table"},{"name":"generate_er_diagram","description":"Generates a Mermaid ER diagram of the database schema"},{"name":"run_read_query","description":"Executes a read-only (SELECT) query on the database"},{"name":"create_table","description":"Create a new table in the database with specified columns and constraints"},{"name":"generate_synthetic_data","description":"Generate and insert synthetic data into an existing table"},{"name":"optimize_sql","description":"Analyze a SQL query using PROFILE and provide optimization recommendations"}],"env_vars":["SINGLESTORE_HOST","SINGLESTORE_PORT"],"auth_type":"none","github":"https://github.com/madhukarkumar/singlestore-mcp-server","homepage":"","server_url":"","status":"active","source":"mcpservers.org","updated_at":"Thu May 28"}