Skip to content
cccskills
FreePublished on GitHub

reindex-gold

Rebuild the pgvector gold index after source data changes. Invoke manually — replaces each collection, do NOT trigger automatically.

The English summary is being prepared. Showing the original description.

Works withPostgreSQL

Run score Not tested

See how to install

Files included (1)

  • SKILL.md2.1 KB

SKILL.md (original)

Review the instructions the agent will receive before you install.

Skill: Rebuild the Gold Index

Use when BDPM/ANSM source data has changed, Silver models were updated, or gold.embedding is missing or stale.

Steps

  1. Ensure Postgres is running (pgvector/pgvector:pg16):

    docker compose up -d
    docker compose ps
    
  2. Ensure Silver is up to date (run if source data changed):

    uv run dotenv -f .env run -- dbt run --project-dir dbt --profiles-dir dbt
    uv run dotenv -f .env run -- dbt test --project-dir dbt --profiles-dir dbt
    
  3. Materialize the Gold asset:

    uv run dotenv -f .env run -- uv run dagster asset materialize --select gold_embeddings
    
  4. Verify row counts:

    uv run dotenv -f .env run -- python -c "
    from sqlalchemy import create_engine, text
    from medox.pipeline.config_pipeline import PipelineSettings
    engine = create_engine(PipelineSettings().postgres_dsn)
    with engine.connect() as conn:
        rows = conn.execute(text('SELECT collection, count(*) FROM gold.embedding GROUP BY 1')).fetchall()
        print(rows)
    "
    
  5. Smoke-test the agent tools:

    uv run dotenv -f .env run -- python -c "
    from medox.agent.tools.tool_search_drug import search_drug
    from medox.agent.tools.tool_check_interactions import check_interactions
    print(search_drug('doliprane'))
    print(check_interactions('warfarine', 'ibuprofene'))
    "
    

Collections

CollectionContentRebuilt from
idx_bdpm_medicament_v1Drug denominations + metadatasilver_bdpm__medicament
idx_ansm_interaction_v1ANSM interaction pairssilver_ansm__interaction

Rules

  • Run dbt tests before reindexing when Silver changed — bad Silver data produces bad embeddings
  • A rebuild replaces one collection inside a transaction — expect several minutes of embedding
  • If gold_embeddings fails, check Postgres is up and the image is pgvector/pgvector:pg16

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

Add a tool function to the Medox agent. Use when creating a tool file, registering it in the API loop, and writing its test.

The English summary is being prepared. Showing the original description.

spideystreet/medox13Updated Oct 1, 2026

Add a new E2E test case to tests/e2e/prompts.yaml for LangSmith evaluation. Use when adding interaction pairs to test, covering new ANSM drug classes, or rebalancing eval coverage.

The English summary is being prepared. Showing the original description.

spideystreet/medox13Updated Oct 1, 2026

commit

Free

Create a git commit with Medox conventions (co-author, conventional type/scope). Invoke manually with /commit — do NOT trigger automatically.

The English summary is being prepared. Showing the original description.

spideystreet/medox13Updated Oct 1, 2026

Audit code changes on the current branch and update docs/ + .claude/rules/ to stay in sync. Run before /pr.

The English summary is being prepared. Showing the original description.

spideystreet/medox13Updated Oct 1, 2026

lint

Free

Run all project linters (ruff, mypy, sqlfluff) and report results. Invoke with /lint.

The English summary is being prepared. Showing the original description.

spideystreet/medox13Updated Oct 1, 2026

Add a new Dagster asset to the pipeline. Use when creating a Bronze, Silver, or Gold layer asset.

The English summary is being prepared. Showing the original description.

spideystreet/medox13Updated Oct 1, 2026

See all skills by spideystreet

Report a problem with this skill