Private credit marks, lender disagreement, Q3 2026 BDC markdowns and banned-vendor exposure from the Tensorust Data API as typed SQL tables, plus a catalog of 145 entity-level datasets with free samples
Compatibility Matrix
This table covers all DuckDB releases that have not reached end-of-life, including LTS releases, and shows the 2 most recent patch releases of each. Older patch releases are not listed, but the extension may be available for them as well.
| Platform | 1.4.4 | 1.4.5 | 1.5.5 | 1.5.6 | 2.0.0 |
|---|---|---|---|---|---|
| Linux AMD64 | |||||
| Linux ARM64 | |||||
| macOS AMD64 | |||||
| macOS ARM64 | |||||
| Windows AMD64 | |||||
| Windows ARM64 | |||||
| WebAssembly |
Installing and Loading
INSTALL tensorust FROM community;
LOAD tensorust;
Example
-- Loans two or more BDC managers mark 10+ points apart, widest gap first.
-- No key needed for the preview.
SELECT company, gap_points, lowest_manager, lowest_mark, highest_manager, highest_mark
FROM tensorust_credit_disagreements();
-- Every fund's mark on one borrower's first-lien loan
SELECT fund, manager, mark, lowest_mark, highest_mark, gap_points
FROM tensorust_lender_marks('Pluralsight');
-- Q3 2026 cuts of 5+ points as each 10-Q is filed
SELECT company, fund, jun30_mark, sep30_mark, change_points, holders_not_filed_yet_above
FROM tensorust_q3_cuts();
-- Federal research awards whose papers name a banned-list vendor
SELECT award, agency, fy25_obligations, vendors, lists
FROM tensorust_exposure('Stanford University');
-- The dataset catalog and a free 25-row sample
SELECT slug, name, rows FROM tensorust_datasets(search := 'BDC');
FROM tensorust_sample('bdc-nonaccrual-watch');
About tensorust
Reads the Tensorust Data API, which is built from public filings: SEC Business Development Company XBRL schedules of investments for private credit, and federal award records matched to 2025-26 papers for vendor exposure.
| Function | One row per |
|---|---|
tensorust_lender_marks(company) |
BDC fund holding the company's first-lien loan, with its mark as a share of par |
tensorust_credit_disagreements() |
loan that two or more BDC managers mark 10+ points apart |
tensorust_q3_cuts() |
fund that cut a loan's mark by 5+ points from Jun 30 to Sep 30 2026 |
tensorust_exposure(institution) |
federal award whose papers name a vendor on the DoD 1260H, Section 889, FCC Covered, UFLPA or BIOSECURE lists |
tensorust_datasets(search := '', category := '') |
dataset in the catalog, with price tiers and sample link |
tensorust_sample(slug) |
row of a dataset's free 25-row sample, with inferred column types |
Columns are typed: marks and dollars are DOUBLE, counts BIGINT, dates DATE, and a
figure the API does not publish stays NULL. Because the results are ordinary tables,
a valuation team can join them to its own book in one query:
SELECT b.borrower, b.my_mark, d.lowest_mark, d.highest_mark, d.gap_points
FROM my_book b
JOIN tensorust_credit_disagreements() d ON lower(d.company) = lower(b.borrower);
Every function works without a key and returns the free preview (for example the top
10 disagreements, or three funds per borrower). With an enterprise key the credit and
exposure functions return full rows: every fund with par, prior-quarter mark, Sep 30
mark and filing link, and every award with its evidence. Set it with
SET tensorust_api_key = 'tdk_...' or the TENSORUST_API_KEY environment variable;
it is sent as an Authorization: Bearer header, never in a URL. Each credit and
exposure row has an access column (preview or full).
Added Functions
| function_name | function_type | description | comment | examples |
|---|---|---|---|---|
| tensorust_credit_disagreements | table | Loans two or more BDC managers mark 10+ points apart at 2026-06-30, widest gap first. Free: the top 10. Enterprise key: the full list. | NULL | [SELECT company, gap_points, lowest_manager, highest_manager FROM tensorust_credit_disagreements()] |
| tensorust_datasets | table | The Tensorust catalog of entity-level datasets (money owed, at risk, mispriced or about to expire), one row per dataset with its price tiers and free sample link. Free. | NULL | [SELECT slug, name, category FROM tensorust_datasets(), SELECT slug, name FROM tensorust_datasets(search := 'BDC')] |
| tensorust_exposure | table | Federal research awards of one recipient (name or UEI) whose 2025-26 papers name a vendor on a banned-vendor list (DoD 1260H, Section 889, FCC Covered List, UFLPA, BIOSECURE). Free: the 5 largest awards. Enterprise key: every award with its evidence sentence and paper link. | NULL | [FROM tensorust_exposure('Stanford University')] |
| tensorust_lender_marks | table | What each BDC fund marks a US company's first-lien loan at (share of par, 2026-06-30 10-Q, plus Sep 30 marks as filed), with the lowest and highest manager and the gap. Free: up to three funds. Enterprise key: every fund with par, prior mark, Q3 mark and filing link. | NULL | [FROM tensorust_lender_marks('Pluralsight')] |
| tensorust_q3_cuts | table | BDC funds that cut a first-lien loan's mark by 5+ points from Jun 30 to Sep 30 2026, pulled from each Q3 10-Q as it is filed, with holders that have not filed yet. Free: the top 10. Enterprise key: every cut and pending holder. | NULL | [SELECT company, fund, jun30_mark, sep30_mark, change_points FROM tensorust_q3_cuts()] |
| tensorust_sample | table | A dataset's free 25-row sample with typed columns, so fields and joins can be checked before buying. Free. | NULL | [FROM tensorust_sample('bdc-nonaccrual-watch')] |
Overloaded Functions
This extension does not add any function overloads.
Added Types
This extension does not add any types.
Added Settings
| name | description | input_type | scope | aliases | typed_value |
|---|---|---|---|---|---|
| temp_directory | Set the directory to which temporary files are written. | VARCHAR | GLOBAL | [] | post.db.tmp |
| tensorust_api_key | Tensorust API key (tdk_…). Empty returns the free preview; an enterprise key returns full rows. | VARCHAR | GLOBAL | [] |