`github.users_list_public_keys_for_user`

pass

List public keys for a user

Requires username. Use LIMIT for spot checks; large result sets paginate quickly.

username captured 2026-08-31 09:29:20Zmedian 39645 ms

Verdict: TRUE

All variants returned rows on ≥2 trials, 0 errors.

rendering…

Summary

Variant	Trials	Min	Median	Max	Row counts
minimal	2	29427 ms	31754 ms	34082 ms	[1, 1]
realistic	2	36160 ms	39645 ms	43130 ms	[1, 1]
edge	2	34351 ms	38517 ms	42684 ms	[1, 1]

Latency per trial

minimalmedian 31754ms

scale: 0–34082 ms

realisticmedian 39645ms

scale: 0–43130 ms

edgemedian 38517ms

scale: 0–42684 ms

Probe variants — every command + output

minimal2 trials

min 29427ms · median 31754ms · max 34082ms · rows 1,1

smallest valid query

Command

SELECT * FROM github.users_list_public_keys_for_user WHERE username = 'FiscalMindset' LIMIT 1

Trials + output

trial 1·29427ms·rows 1isError=false

First row (click to expand JSON)

{
  "created_at": "2026-03-24T04:14:35Z",
  "id": "146486940",
  "key": "ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIIwJeXROyVcUp0yyw794yewfNc+ISsNypI40/+9UAWvi",
  "last_used": "2026-08-29T19:01:21Z",
  "username": "FiscalMindset"
}

columns (5)

created_atidkeylast_usedusername

trial 2·34082ms·rows 1isError=false

First row (click to expand JSON)

{
  "created_at": "2026-03-24T04:14:35Z",
  "id": "146486940",
  "key": "ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIIwJeXROyVcUp0yyw794yewfNc+ISsNypI40/+9UAWvi",
  "last_used": "2026-08-29T19:01:21Z",
  "username": "FiscalMindset"
}

columns (5)

created_atidkeylast_usedusername

realistic2 trials

min 36160ms · median 39645ms · max 43130ms · rows 1,1

typical user query

Command

SELECT * FROM github.users_list_public_keys_for_user WHERE username = 'FiscalMindset' LIMIT 25

Trials + output

trial 1·43130ms·rows 1isError=false

First row (click to expand JSON)

{
  "created_at": "2026-03-24T04:14:35Z",
  "id": "146486940",
  "key": "ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIIwJeXROyVcUp0yyw794yewfNc+ISsNypI40/+9UAWvi",
  "last_used": "2026-08-29T19:01:21Z",
  "username": "FiscalMindset"
}

columns (5)

created_atidkeylast_usedusername

trial 2·36160ms·rows 1isError=false

First row (click to expand JSON)

{
  "created_at": "2026-03-24T04:14:35Z",
  "id": "146486940",
  "key": "ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIIwJeXROyVcUp0yyw794yewfNc+ISsNypI40/+9UAWvi",
  "last_used": "2026-08-29T19:01:21Z",
  "username": "FiscalMindset"
}

columns (5)

created_atidkeylast_usedusername

edge2 trials

min 34351ms · median 38517ms · max 42684ms · rows 1,1

edge: larger limit

Command

SELECT * FROM github.users_list_public_keys_for_user WHERE username = 'FiscalMindset' LIMIT 200

Trials + output

trial 1·34351ms·rows 1isError=false

First row (click to expand JSON)

{
  "created_at": "2026-03-24T04:14:35Z",
  "id": "146486940",
  "key": "ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIIwJeXROyVcUp0yyw794yewfNc+ISsNypI40/+9UAWvi",
  "last_used": "2026-08-29T19:01:21Z",
  "username": "FiscalMindset"
}

columns (5)

created_atidkeylast_usedusername

trial 2·42684ms·rows 1isError=false

First row (click to expand JSON)

{
  "created_at": "2026-03-24T04:14:35Z",
  "id": "146486940",
  "key": "ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIIwJeXROyVcUp0yyw794yewfNc+ISsNypI40/+9UAWvi",
  "last_used": "2026-08-29T19:01:21Z",
  "username": "FiscalMindset"
}

columns (5)

created_atidkeylast_usedusername

All returned rowsacross all non-errored trials · filterable · paginated

6 rows stored · 6 returned · page 1/1


1	0	2026-03-24T04:14:35Z	146486940	ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIIwJeXROyVcUp0yyw794yewfNc+ISsNypI40/+9UAWvi	2026-08-29T19:01:21Z	FiscalMindset
2	1	2026-03-24T04:14:35Z	146486940	ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIIwJeXROyVcUp0yyw794yewfNc+ISsNypI40/+9UAWvi	2026-08-29T19:01:21Z	FiscalMindset
1	2	2026-03-24T04:14:35Z	146486940	ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIIwJeXROyVcUp0yyw794yewfNc+ISsNypI40/+9UAWvi	2026-08-29T19:01:21Z	FiscalMindset
2	3	2026-03-24T04:14:35Z	146486940	ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIIwJeXROyVcUp0yyw794yewfNc+ISsNypI40/+9UAWvi	2026-08-29T19:01:21Z	FiscalMindset
1	4	2026-03-24T04:14:35Z	146486940	ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIIwJeXROyVcUp0yyw794yewfNc+ISsNypI40/+9UAWvi	2026-08-29T19:01:21Z	FiscalMindset
2	5	2026-03-24T04:14:35Z	146486940	ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIIwJeXROyVcUp0yyw794yewfNc+ISsNypI40/+9UAWvi	2026-08-29T19:01:21Z	FiscalMindset

Column profile

5 columns actually returned by coral. Catalog claims "1 required filter(s)": "username". Click a column to drill in.

#	Column	Inferred type	Non-null	Sample value(s)
1	created_at	string	6	`"2026-03-24T04:14:35Z"`
2	id	string	6	`"146486940"`
3	key	string	6	`"ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIIwJeXROyVcUp0yyw794yewf"`
4	last_used	string	6	`"2026-08-29T19:01:21Z"`
5	username	string	6	`"FiscalMindset"`

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	29427ms	1	ok	created_at, id, key
minimal	t2	34082ms	1	ok	created_at, id, key
realistic	t1	43130ms	1	ok	created_at, id, key
realistic	t2	36160ms	1	ok	created_at, id, key
edge	t1	34351ms	1	ok	created_at, id, key
edge	t2	42684ms	1	ok	created_at, id, key

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

Requires username. Use LIMIT for spot checks; large result sets paginate quickly.

Columns coral returned (5)

created_atidkeylast_usedusername

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-08-31T09:29:20Z

JSON record: reports/github/tables/users_list_public_keys_for_user.json

first_run_at: 2026-08-31T09:29:20Z

last_retried_at: 2026-08-31T09:29:20Z

retry_count: 0

View version history →