This is an MCP (Model Context Protocol) server implementation that provides LLMs with MySQL database access. The server exposes a single `mysql_query` tool for executing SQL queries and resources for listing tables and column metadata. It supports both stdio and HTTP transport modes, the latter with bearer token authentication. Key features include multi-database mode (querying across schemas without reconnection), schema-specific write permissions (INSERT/UPDATE/DELETE/DDL per database), SSL/TLS with mTLS, Unix socket connections, and a sophisticated PII redaction system that combines column-name heuristics with regex value scanning and Luhn-verified credit card detection. The architecture is monolithic: a single Express server (or stdio process) manages a mysql2 connection pool and routes all MCP protocol requests through zod-validated schemas. The codebase is well-tested with unit, integration, and end-to-end test suites, and demonstrates careful engineering in areas like query parsing (using node-sql-parser), permission enforcement, and secure defaults (write operations disabled by default).
This is a monorepo of ~100 Claude Code skills — self-contained plugins that extend Claude Code's capabilities across personal automation, research, content creation, development tooling, and communication. Each skill is a directory with a SKILL.md (trigger definition), scripts/, references/, and assets/. The architecture is plugin-based: Claude Code matches user requests to skill triggers and executes the associated scripts. Skills range from simple CLI wrappers (e.g., YouTube transcript extraction) to multi-step pipelines (e.g., PII redaction with confide, release orchestration with cull-release, interview-driven skill design with skill-studio). The codebase demonstrates strong patterns: reversible PII redaction with typed placeholders, exact permutation statistics, weighted scoring with Pareto frontiers, and structured TDD loops. However, it also has technical debt: hardcoded user paths, some deprecated library usage, external API coupling, and a few design-spec-only skills. The dominant character is application (CLI tools and agent plugins), though several skills involve data analysis (health queries, experiment evaluation, evidence grading).