database-lookup

Query 78 documented public database APIs with reproducible endpoints, pagination, and provenance.

Updated Aug 28, 2026
One-click install
npx skills add https://github.com/AnderHonorato/Mem-rias-IA---Infinity --skill database-lookup-anderhonorato
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database-lookup
Source: https://github.com/AnderHonorato/Mem-rias-IA---Infinity/tree/main/Manus/Skills/snapshots/kdense-database-lookup
Command: npx skills add https://github.com/AnderHonorato/Mem-rias-IA---Infinity --skill database-lookup-anderhonorato

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve? Retrieving facts from scientific, regulatory, financial, and demographic databases often fails due to wrong identifier formats, incomplete pagination, undocumented rate limits, and missing provenance. This Skill turns a user's intent into a reproducible, auditable API retrieval across 78 documented public databases instead of relying on inferred general knowledge. ## Core Features & Use Cases - Guided database selection: A selection guide maps user intent to the authoritative database across domains like genomics, chemistry, clinical trials, patents, economics, and demographics, with per-database reference files covering endpoints, parameters, and worked examples. - Reproducible retrieval workflow: Enforces a retrieval contract with explicit filters, identifier conversion (e.g., gene symbol to NCBI Gene ID to Ensembl ID), count-first pagination, and count reconciliation so results can be repeated by another agent or human. - Safe API execution: Handles POST-only GraphQL APIs, API key discovery without exposing secrets, rate-limit serialization, URL encoding of special characters, and treats all API responses as untrusted third-party data. - Use Case: A researcher asks for all clinical trials and known binding affinities for a compound. The Skill resolves the compound name to a PubChem CID, queries ClinicalTrials.gov and BindingDB with bounded paginated calls, and returns a structured result table with endpoints, access dates, and count reconciliation. ## Quick Start Ask the assistant to look up a specific fact from a named public database, such as retrieving all UniProt entries for a given human gene with full provenance.

Frequently Asked Questions about database-lookup

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I query public scientific databases like PubChem or UniProt from an AI assistant?

Define the target entity and constraints, then read the database's reference file for endpoints and parameters before making bounded API calls. Convert identifiers to the format each database expects, paginate until counts reconcile, and return results with endpoints, parameters, and access date for reproducibility.

What should I do when a gene symbol or compound name is not recognized by a database API?

The identifier format is likely wrong for that database. Convert gene symbols via NCBI Gene to NCBI Gene ID or Ensembl ID, and resolve compound names through PubChem to a CID, then retry with SMILES, InChIKey, or CAS number if needed.

Which databases require API keys and how are credentials handled safely?

Databases like FRED, BEA, BLS, NCBI, OpenFDA, and Materials Project require free API keys passed as documented parameters. Only the single named environment variable is checked, keys are never printed or included in provenance, and anonymous lower-rate access is used when a key is absent.

Why do some database APIs fail with GET requests or WebFetch tools?

APIs like Open Targets, gnomAD, RummaGEO, and GDC require HTTP POST, often for GraphQL or complex filter queries, so GET-only fetch tools cannot reach them. Use curl via a shell tool with a JSON body and appropriate Content-Type header instead.

How do I make sure an exhaustive database retrieval is complete and not silently truncated?

Call a count endpoint first when available, retrieve in deterministic order, record every page or batch, and reconcile expected versus retrieved totals. If pagination stops early or counts disagree, report the limitation explicitly rather than presenting a partial dataset as complete.

What are the limits on large bulk retrievals from these database APIs?

Retrievals are bounded at 10,000 records or 100 API calls unless the user explicitly confirms a larger plan. For very large sources like PubChem, ChEMBL, or ZINC, official bulk downloads or database dumps are preferred over looping through API pages.