kltng/columbia-clio
columbia-clio/SKILL.md
Search Columbia University Libraries' CLIO catalog for books, journals, manuscripts, and other holdings via its Blacklight JSON API. Use this skill whenever the user wants to look up items in Columbia's library, check availability of books at Columbia, search by title/author/subject with faceted filtering by format/language/location, or retrieve detailed catalog records including call numbers and holdings data. Triggers when referencing Columbia University collections or Ivy League library holdings.
$ install --global
skillsauthnpx skillsauth add kltng/humanities-skills columbia-clioInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: May 28, 2026, 7:29 AM119.6s4 files scanned
SKILL.md
- name:
- columbia-clio
- description:
- Search Columbia University Libraries' CLIO catalog for books, journals, manuscripts, and other holdings via its Blacklight JSON API. Use this skill whenever the user wants to look up items in Columbia's library, check availability of books at Columbia, search by title/author/subject with faceted filtering by format/language/location, or retrieve detailed catalog records including call numbers and holdings data. Triggers when referencing Columbia University collections or Ivy League library holdings.
- version:
- 1.0.0
Columbia CLIO Catalog Skill
Search Columbia University Libraries' catalog of books, journals, manuscripts, and more.
Critical: Things Claude Won't Know Without This Skill
CLIO has an undocumented but fully functional JSON API
CLIO runs on Blacklight (Solr-based). Append .json to catalog URLs for JSON responses. No API key required.
Search: https://clio.columbia.edu/catalog.json?q=hamlet&per_page=10
Record: https://clio.columbia.edu/catalog/{id}.json
Field-specific search uses search_field parameter
All fields: ?q=hamlet
Title only: ?q=hamlet&search_field=title
Author: ?q=shakespeare&search_field=author
Facets use array bracket syntax
?f[format][]=Book
?f[language_facet][]=Chinese&f[format][]=Book
Available facets: format, language_facet, location_facet, subject_topic_facet, subject_geo_facet, subject_era_facet, subject_form_facet, pub_date_sort.
This is undocumented — be a good citizen
No rate limits are documented, but this is an unofficial API. Keep requests to 1/second max. The official bulk data is at https://lito.cul.columbia.edu/extracts/ColumbiaLibraryCatalog/full/ (MARCXML, CC0).
Key Search Parameters
| Param | Description | Example |
|-------|-------------|---------|
| q | Search query | q=dream+of+the+red+chamber |
| search_field | Limit to field: title, author, or all | search_field=title |
| per_page | Results per page (default ~10) | per_page=25 |
| page | Page number | page=2 |
| sort | Sort: pub_date_sort+desc, pub_date_sort+asc | sort=pub_date_sort+desc |
| f[facet][] | Filter by facet value | f[format][]=Book |
Response Structure
{
"response": {
"docs": [
{
"id": "12345678",
"title_display": "Hamlet",
"author_display": "Shakespeare, William, 1564-1616",
"format": ["Book"],
"pub_year_display": ["2003"],
"pub_name_display": ["Cambridge University Press"],
"language_facet": ["English"],
"isbn_display": ["9780521532525"],
"location_call_number_id_display": ["Butler Stacks PR2807 .A2 T48 2003 "]
}
],
"facets": [ ... ],
"pages": {
"current_page": 1,
"total_pages": 5330,
"total_count": 10659,
"next_page": 2
}
}
}
Key Document Fields
| Field | Description |
|-------|-------------|
| id | Catalog record ID |
| title_display | Title |
| author_display | Primary author |
| author_facet | All authors (array) |
| format | Format (Book, Online, Music, etc.) |
| pub_year_display | Publication year(s) |
| pub_name_display | Publisher |
| pub_place_display | Place of publication |
| language_facet | Language(s) |
| isbn_display | ISBN(s) |
| oclc_display | OCLC number(s) |
| lccn_display | LCCN(s) |
| subject_topic_facet | Subject terms |
| location_call_number_id_display | Location + call number |
| physical_description_display | Physical description |
Python Script
from scripts.clio_api import ColumbiaClioAPI
clio = ColumbiaClioAPI()
# Search
results = clio.search("hamlet", search_field="title", per_page=10)
# With facets
results = clio.search("chinese poetry", facets={"format": "Book", "language_facet": "Chinese"})
# Get single record
record = clio.get_record("12345678")
# Summarize
for r in results:
print(clio.summarize(r))
Related Skills
- harvard-library-catalog: Compare holdings across Harvard and Columbia
- hathitrust-catalog: Use ISBNs/OCLCs from CLIO to check HathiTrust for digital versions
- wikidata-search: Link OCLC numbers to Wikidata entities
Resources
references/api_reference.md— Complete field and facet referencescripts/clio_api.py— Python client with search, record lookup, and faceted filtering
Related Skills
kltng/cbdb-local
development
VerifiedTrustedCommunity
Query the China Biographical Database (CBDB) locally via SQLite for biographical data on 656K+ historical Chinese figures from the 7th century BCE through the 19th century CE. Use when searching for Chinese historical figures, scholars, officials, or literary figures — their biographical details, family/kinship networks, official postings, social associations, examination records, or addresses. Runs entirely locally after initial database download (~556 MB). Faster and more flexible than the API version.
3SKILL.mdUpdated May 28, 2026
kltng/zotero-local
development
VerifiedTrustedCommunity
Interact with a local Zotero 8 desktop application through its HTTP API at localhost:23119. Use this skill whenever the user wants to search, fetch, add, edit, or organize bibliographic items in their Zotero library, import citations (BibTeX, RIS, etc.), attach files, manage collections and tags, or retrieve full-text content from Zotero. Triggers on mentions of Zotero, citation management, reference libraries, bibliographic databases, or local library management. Also use when chaining with other catalog skills (Harvard, LOC, HathiTrust, etc.) to save found records into the user's Zotero library.
2SKILL.mdUpdated May 28, 2026
kltng/wikidata-search
development
VerifiedTrustedCommunity
Search for items and properties on Wikidata and retrieve entity details, claims, and external identifiers. Supports both keyword search (Wikidata Action API) and semantic/hybrid search (Wikidata Vector Database), plus direct entity retrieval (Special:EntityData) and structured querying (WDQS SPARQL).
2SKILL.mdUpdated May 28, 2026
kltng/tgaz-query
testing
VerifiedTrustedCommunity
Query and explore the TGAZ (Temporal Gazetteer) SQLite database of 82,000+ historical Chinese placenames spanning 763 BCE to 1911 CE. Use this skill whenever the user asks about historical Chinese places, administrative geography, dynastic jurisdictions, place name evolution, or wants to query tgaz.db. Also trigger when the user mentions CHGIS, TGAZ, historical gazetteer, Chinese historical GIS, or asks questions like "what was X called in dynasty Y", "what counties existed in year Z", "where was X located", or any spatial/temporal query about Chinese historical geography. This skill is relevant even for casual questions like "tell me about ancient Chang'an" or "Tang dynasty cities near the Yellow River".
2SKILL.mdUpdated May 28, 2026