lifesciences-research: Command for Claude Code

Generate development environment statistics for Docker Neo4j namespace management and cleanup.

Instructions

Execute these queries sequentially to build a development environment report. Report results to the user in a formatted summary.

Purpose: Namespace cleanup, development progress tracking, and quick sanity checks.

Query 1: Namespace Overview

mcp__neo4j-docker-cypher__read_neo4j_cypher(
    query="""
    MATCH (e:Episodic)
    RETURN e.group_id AS namespace,
           count(*) AS episodes,
           min(e.created_at) AS first_episode,
           max(e.created_at) AS last_episode
    ORDER BY episodes DESC
    """
)

Purpose: Shows all namespaces with episode counts and identifies cleanup candidates.

Query 2: Development Namespace Breakdown

mcp__neo4j-docker-cypher__read_neo4j_cypher(
    query="""
    MATCH (e:Episodic)
    WHERE e.group_id STARTS WITH 'dev_'
       OR e.group_id STARTS WITH 'test_'
       OR e.group_id STARTS WITH 'experimental_'
       OR e.group_id STARTS WITH 'scratch_'
       OR e.group_id STARTS WITH 'demo_'
    RETURN e.group_id AS namespace,
           count(*) AS episodes,
           max(e.created_at) AS last_activity
    ORDER BY last_activity DESC
    """
)

Purpose: Identifies development namespaces with activity timestamps for cleanup decisions.

Query 3: Total Graph Size

mcp__neo4j-docker-cypher__read_neo4j_cypher(
    query="""
    MATCH (n:Entity)
    WITH count(n) AS entity_count
    MATCH ()-[r]->()
    RETURN entity_count,
           count(r) AS relationship_count
    """
)

Purpose: Simple counts for development environment capacity check.

Query 4: Recent Activity (Last 7 Days)

mcp__neo4j-docker-cypher__read_neo4j_cypher(
    query="""
    MATCH (e:Episodic)
    WHERE e.created_at > datetime() - duration('P7D')
    RETURN e.group_id AS namespace,
           count(*) AS recent_episodes,
           max(e.created_at) AS last_episode
    ORDER BY recent_episodes DESC
    """
)