sql/select_spaces.sql

SELECT 
    s.space_id,
    s.title,
    s.description,
    s.url as space_url,
    s.tags,
    e.endpoint_url as schema_url,
    COUNT(t.tool_name) as tool_count
FROM spaces s
JOIN endpoints e ON s.space_id = e.space_id AND e.endpoint_type = 'schema'
JOIN tools t ON s.space_id = t.space_id
GROUP BY s.space_id, s.title, s.description, s.url, s.tags, e.endpoint_url
HAVING tool_count > 0;