{"name":"Neuroconnective Research Database","description":"Public read-only SQL database covering the neuroconnective phenotype: hEDS, MCAS, POTS, ADHD, autism, AERD, migraine, fibromyalgia, and related conditions. 15,900+ PubMed articles, 390+ tables, 97M rows.","query_endpoint":{"methods":["GET","POST"],"url":"/query","GET_usage":"GET /query?sql=SELECT+title+FROM+article+LIMIT+5","POST_usage":{"sql":"SELECT ...","max_rows":5000},"wildcard_note":"Use * instead of % for ILIKE wildcards in GET URLs (avoids URL encoding issues). Use + for spaces.","example_urls":["https://mcasdata.com/query?sql=SELECT+title,+abstract_text+FROM+article+WHERE+title+ILIKE+'*omalizumab*'+LIMIT+10","https://mcasdata.com/query?sql=SELECT+title,+abstract_text+FROM+article+WHERE+title+ILIKE+'*xolair*'+OR+abstract_text+ILIKE+'*xolair*'+LIMIT+10","https://mcasdata.com/query?sql=SELECT+name,+mechanism,+drug_class+FROM+drug_library+WHERE+name+ILIKE+'*omalizumab*'","https://mcasdata.com/query?sql=SELECT+count(*)+as+total_articles+FROM+article","https://mcasdata.com/query?sql=SELECT+title+FROM+article+WHERE+abstract_text+ILIKE+'*mast+cell*'+AND+abstract_text+ILIKE+'*treatment*'+LIMIT+10"]},"other_endpoints":{"GET /schema":"List all tables grouped by category","GET /schema/{table_name}":"Describe a table (columns, types, sample rows)","GET /queries":"List pre-built query registry","POST /queries/{query_id}/run":"Run a pre-built query by ID","GET /health":"Health check"},"key_tables":["article — 15,900+ articles with title, abstract_text, keywords, dates","article_fulltext — Full text with parsed sections (intro/methods/results/discussion)","article_mesh — MeSH terms per article","drug_library — Drug entities with class, mechanism, external IDs","gene — 67K+ genes (NCBI gene_id, symbol, aliases)","disease_ref_unified — 280K diseases with cross-ontology mappings"],"notes":"All queries are read-only. Rate limited to 10 queries/minute."}