How do I install the Jgi Lakehouse skill?

Run npx skillmds@latest add tomevault-io/jgi-lakehouse in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Jgi Lakehouse safe to use?

This skill has not completed SkillMD's automated safety review yet. Independent scanners report: SkillSpector: PASS, Skill Scanner: FAIL. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Jgi Lakehouse?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Jgi Lakehouse free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Jgi Lakehouse?

tomevault-io (@tomevault-io) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Jgi Lakehouse by tomevault-io — Agent Skill

Name: Jgi Lakehouse
Author: tomevault-io

Jgi Lakehouse

Skills for querying the JGI Dremio Lakehouse containing GOLD and IMG genomics databases. Use this when users want to explore JGI databases, query GOLD (Genomes OnLine Database), IMG (Integrated Microbial Genomes), or run SQL queries against JGI genomics data. Triggers on mentions of JGI, GOLD database, IMG database, genome metadata, or JGI lakehouse queries. Use when this capability is needed.

tomevault-io Updated Sep 17, 2026

File contents

JGI Lakehouse Query

Query the JGI Dremio Lakehouse via CLI.

Setup

pip install linkml-store[dremio]
export DREMIO_USER="your_username"
export DREMIO_PASSWORD="your_password"

Connection

# Base connection (no schema filter)
DB="dremio-rest://lakehouse.jgi.lbl.gov"

# GOLD database
GOLD="dremio-rest://lakehouse.jgi.lbl.gov?schema=gold-db-2 postgresql.gold"

# IMG Core database
IMG="dremio-rest://lakehouse.jgi.lbl.gov?schema=img-db-2 postgresql.img_core_v400"

SQL Queries

Direct SQL via --sql flag:

# Query GOLD studies
linkml-store -d "$DB" query --sql 'SELECT * FROM "gold-db-2 postgresql".gold.study LIMIT 10'

# Count by ecosystem
linkml-store -d "$DB" query --sql 'SELECT ecosystem, COUNT(*) as cnt FROM "gold-db-2 postgresql".gold.study GROUP BY ecosystem ORDER BY cnt DESC'

# Join tables
linkml-store -d "$DB" query --sql 'SELECT s.study_name, p.project_name FROM "gold-db-2 postgresql".gold.study s JOIN "gold-db-2 postgresql".gold.project p ON s.study_id = p.study_id LIMIT 10'

# Output formats
linkml-store -d "$DB" query --sql '...' -O json
linkml-store -d "$DB" query --sql '...' -O csv
linkml-store -d "$DB" query --sql '...' -O yaml

Collection Queries

When schema is set, use collection-based queries:

# List tables
linkml-store -d "$GOLD" list-collections

# Query collection
linkml-store -d "$GOLD" -c study query --limit 10

# With filter
linkml-store -d "$GOLD" -c study query -w "ecosystem=Host-associated" --limit 20

# Describe table
linkml-store -d "$GOLD" -c study describe

Schema Export

# Export LinkML schema with FK relationships
linkml-store -d "$GOLD" schema -O yaml -o gold.linkml.yaml

Key Databases

Schema Path	Tables	Description
`"gold-db-2 postgresql".gold`	42	GOLD - genome project metadata
`"img-db-2 postgresql".img_core_v400`	244	IMG Core - genes, taxa, annotations
`"img-db-2 postgresql".img_ext`	84	IMG Extended data
`"img-db-2 postgresql".img_sat_v450`	141	IMG Satellite/experimental

See references/databases.md for complete listing.

Common SQL Patterns

# List schemas
linkml-store -d "$DB" query --sql 'SELECT TABLE_SCHEMA, COUNT(*) as tables FROM INFORMATION_SCHEMA."TABLES" GROUP BY TABLE_SCHEMA ORDER BY TABLE_SCHEMA'

# List tables in schema
linkml-store -d "$DB" query --sql 'SELECT TABLE_NAME FROM INFORMATION_SCHEMA."TABLES" WHERE TABLE_SCHEMA = '''gold-db-2 postgresql.gold''' ORDER BY TABLE_NAME'

# Table columns
linkml-store -d "$DB" query --sql 'SELECT COLUMN_NAME, DATA_TYPE FROM INFORMATION_SCHEMA."COLUMNS" WHERE TABLE_SCHEMA = '''gold-db-2 postgresql.gold''' AND TABLE_NAME = '''study''' ORDER BY ORDINAL_POSITION'

# Row count
linkml-store -d "$DB" query --sql 'SELECT COUNT(*) FROM "gold-db-2 postgresql".gold.study'

Pre-generated Schemas

LinkML schemas with FK relationships: /Users/cjm/repos/linkml-store/jgi-lakehouse-analysis/

Source: openscientist-io/openscientist — distributed by TomeVault.

---name: jgi-lakehousedescription: Skills for querying the JGI Dremio Lakehouse containing GOLD and IMG genomics databases. Use this when users want to explore JGI databases, query GOLD (Genomes OnLine Database), IMG (Integrated Microbial Genomes), or run SQL queries against JGI genomics data. Triggers on mentions of JGI, GOLD database, IMG database, genome metadata, or JGI lakehouse queries. Use when this capability is needed.---# JGI Lakehouse QueryQuery the JGI Dremio Lakehouse via CLI.## Setup```bashpip install linkml-store[dremio]export DREMIO_USER="your_username"export DREMIO_PASSWORD="your_password"```## Connection```bash# Base connection (no schema filter)DB="dremio-rest://lakehouse.jgi.lbl.gov"# GOLD databaseGOLD="dremio-rest://lakehouse.jgi.lbl.gov?schema=gold-db-2 postgresql.gold"# IMG Core databaseIMG="dremio-rest://lakehouse.jgi.lbl.gov?schema=img-db-2 postgresql.img_core_v400"```## SQL QueriesDirect SQL via `--sql` flag:```bash# Query GOLD studieslinkml-store -d "$DB" query --sql 'SELECT * FROM "gold-db-2 postgresql".gold.study LIMIT 10'# Count by ecosystemlinkml-store -d "$DB" query --sql 'SELECT ecosystem, COUNT(*) as cnt FROM "gold-db-2 postgresql".gold.study GROUP BY ecosystem ORDER BY cnt DESC'# Join tableslinkml-store -d "$DB" query --sql 'SELECT s.study_name, p.project_name FROM "gold-db-2 postgresql".gold.study s JOIN "gold-db-2 postgresql".gold.project p ON s.study_id = p.study_id LIMIT 10'# Output formatslinkml-store -d "$DB" query --sql '...' -O jsonlinkml-store -d "$DB" query --sql '...' -O csvlinkml-store -d "$DB" query --sql '...' -O yaml```## Collection QueriesWhen schema is set, use collection-based queries:```bash# List tableslinkml-store -d "$GOLD" list-collections# Query collectionlinkml-store -d "$GOLD" -c study query --limit 10# With filterlinkml-store -d "$GOLD" -c study query -w "ecosystem=Host-associated" --limit 20# Describe tablelinkml-store -d "$GOLD" -c study describe```## Schema Export```bash# Export LinkML schema with FK relationshipslinkml-store -d "$GOLD" schema -O yaml -o gold.linkml.yaml```## Key Databases| Schema Path | Tables | Description ||-------------|--------|-------------|| `"gold-db-2 postgresql".gold` | 42 | GOLD - genome project metadata || `"img-db-2 postgresql".img_core_v400` | 244 | IMG Core - genes, taxa, annotations || `"img-db-2 postgresql".img_ext` | 84 | IMG Extended data || `"img-db-2 postgresql".img_sat_v450` | 141 | IMG Satellite/experimental |See [references/databases.md](references/databases.md) for complete listing.## Common SQL Patterns```bash# List schemaslinkml-store -d "$DB" query --sql 'SELECT TABLE_SCHEMA, COUNT(*) as tables FROM INFORMATION_SCHEMA."TABLES" GROUP BY TABLE_SCHEMA ORDER BY TABLE_SCHEMA'# List tables in schemalinkml-store -d "$DB" query --sql 'SELECT TABLE_NAME FROM INFORMATION_SCHEMA."TABLES" WHERE TABLE_SCHEMA = '''gold-db-2 postgresql.gold''' ORDER BY TABLE_NAME'# Table columnslinkml-store -d "$DB" query --sql 'SELECT COLUMN_NAME, DATA_TYPE FROM INFORMATION_SCHEMA."COLUMNS" WHERE TABLE_SCHEMA = '''gold-db-2 postgresql.gold''' AND TABLE_NAME = '''study''' ORDER BY ORDINAL_POSITION'# Row countlinkml-store -d "$DB" query --sql 'SELECT COUNT(*) FROM "gold-db-2 postgresql".gold.study'```## Pre-generated SchemasLinkML schemas with FK relationships: `/Users/cjm/repos/linkml-store/jgi-lakehouse-analysis/`---> Source: [openscientist-io/openscientist](https://github.com/openscientist-io/openscientist) — distributed by [TomeVault](https://tomevault.io).

Frequently asked questions