Jerry Nixon
Developer
2
APPEARANCES
2
PODCASTS
012
DEC 30
JAN 6
JAN 13
JAN 20
JAN 27
FEB 3
FEB 10
FEB 17
FEB 24
MAR 3
MAR 10
MAR 17
MAR 24
MAR 31
APR 7
APR 14
APR 21
APR 28
MAY 5
MAY 12
MAY 19
MAY 26
JUN 2
JUN 9
JUN 16
JUN 23
JUN 30
JUL 7
JUL 14
JUL 21
JUL 28
AUG 4
AUG 11
AUG 18
AUG 25
SEP 1
SEP 8
SEP 15
SEP 22
SEP 29
OCT 6
OCT 13
OCT 20
OCT 27
NOV 3
NOV 10
NOV 17
NOV 24
DEC 1
DEC 8
DEC 15
DEC 22
DEC 29
JAN 5
JAN 12
JAN 19
JAN 26
FEB 2
FEB 9
FEB 16
FEB 23
MAR 2
MAR 9
MAR 16
MAR 23
MAR 30
APR 6
APR 13
APR 20
APR 27
MAY 4
MAY 11
MAY 18
MAY 25
JUN 1
JUN 8
JUN 15
JUN 22
JUN 29
JUL 6
JUL 13
JUL 20
JUL 27
AUG 3
AUG 10
AUG 17
AUG 24
AUG 31
SEP 7
SEP 14
SEP 21
Jul 24, 2026
Giving AI Agents Safe Access to Your Data: SQL MCP Server with Jerry Nixon
6:41
6:53
33:27

Jamie TaylorHOST
Just to sort of level set, is that kind of, am I on the right tracks as to what an MCP is?

Jerry NixonGUEST
There's so many analogies here, but if we start with an onion, at the heart of everything is an LLM.
26 MINS LATER

Jamie TaylorHOST
So yeah, I love that idea of being able to not necessarily trace things back for a malicious reason of like, hey, you're using a babillion tokens and you're causing bottlenecks in the database, but more a case of, Somebody dropped the production server
Data API Builder and SQL MCP with Jerry Nixon
5:02
10:17
10:26

Jerry NixonGUEST
The hardest part next would be what if you upgrade to the next version of Entity Framework, but your other application doesn't upgrade to the next version of Entity Framework? What are the heuristics of the queries that are being written, and what are, and what are the-- I don't know, what's the wild hair that the developer is using to write some sort of a LINQ or Lambda statement that makes the query-

Jerry NixonGUEST
So now you can have not just two endpoint types, you can have a third endpoint type for your agents all being configured by a single JSON file.

Jerry NixonGUEST
And they all share the same configuration, which it, the important part of that is now your agents have the same sort of gu- guardrails and guidance, have the same sort of, uh, pr- uh, forced predicates, the same sort of security authorization, and all this cool functionality around, um, caching and paging and filtering and stuff like that that you would want to give to your app builders, you can now give it to your agents as well.