Mcp

I’ve been building an MCP server for a client that connects various tools for querying our DuckDB-based warehouse (managed with dbt). The authentication piece had me stuck for way too long - but I finally cracked it! The Problem We’re running Authentik as our OAuth 2.0 provider. It’s solid and OAuth 2.0 compliant, but here’s the catch: it doesn’t support Dynamic Client Registration (DCR). Meanwhile, MCP clients expect DCR-based OAuth flows. ...

I just discovered that Claude Code can function as an MCP (Model Context Protocol) server. This seems like it could be incredibly powerful! I haven’t had a chance to explore it yet, but the implications are exciting. It could enable entirely new workflows where Claude Code serves as a backend for other MCP clients like: Claude Desktop app VS Code extensions Other MCP-compatible tools The idea of having Claude Code as a programmable server that other tools can interact with opens up some interesting automation possibilities. You could potentially have Claude Code running in the background, handling requests from various clients and coordinating complex development tasks. ...

I was working on a job for a client and had extracted a subset of production data into a duckdb database. I then set up the DuckDB MCP client (with my read-only mode flag turned on) I then fired up Claude Desktop and entered the following (note some data has been blanked out for privacy): I want to use the PRODUCTION_SCHEDULE table to find gaps in the coming months where the nothing will be running on production lines with `line_number` LINEABC1 and LINEABC2. The table has one row per scheduled run and has START and END columns to show when each run will begin and end. Can you write a query that will show us the gaps in between these runs between today and the end of september, 2025? Claude sonnet 3.7 churned away for about 40 seconds and produced an excellent result: ...