We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/cobanov/teslamate-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server
most_visited_locations.sql•346 B
SELECT a.display_name as location,
a.city,
a.state,
COUNT(*) as visit_count,
SUM(d.duration_min) as total_time_spent_min
FROM drives d
JOIN addresses a ON (
d.start_address_id = a.id
OR d.end_address_id = a.id
)
GROUP BY a.id,
a.display_name,
a.city,
a.state
ORDER BY visit_count DESC
LIMIT 15;