{"data":{"slug":"slayer","name":"SLayer","tagline":"MIT embeddable semantic layer for agents — MCP, SQL expressions, dbt/Cube import","category":"agents","categoryName":"AI Agents","url":"https://motley.ai/slayer","github":"https://github.com/MotleyAI/slayer","pricing":"open-source","hook":"SLayer is a semantic layer built for agent search→inspect→query — define metrics once, ask with expressions, expose MCP/REST/CLI/Flight SQL without forcing classic BI pre-aggregations.","whatsGood":"MIT (MotleyAI/slayer). uv-installable Python library and standalone tool with MCP, REST, CLI, Flight SQL, and a Postgres-shaped SQL facade. Expression queries (sum/avg/ratios/time_shift) plus memory/search for business context. Imports dbt, Cube, and Ossie configs so you can sit beside an existing warehouse stack instead of replacing it.","theCatch":"Vs warehouse/BI tools and raw SQL MCP: SLayer is the metric/expression layer agents query, not a database or a full BI product. You still own warehouse credentials, row-level security design, and whether definitions stay truthful. Young Motley surface — verify connectors for your engine before betting a production agent on it.","verdict":"OSS semantic layer for agentic analytics. Expressions + MCP over your warehouse; not another vector RAG pack.","addedAt":"2026-09-19","featured":false,"domain":"AI Agents","subSpecialty":"Agents","subcategory":"MCP","tags":["mcp","cli","api","self-host","permissive","observability","active"],"capabilities":["mcp","cli"],"surfaces":["MCP","CLI","API","Self-host"],"ecosystem":["Multi-platform"],"licenseModel":"OSS/MIT","githubStars":303,"starsPerWeek":10,"access":"free","archived":false,"repo":{"createdAt":"2026-03-17","pushedAt":"2026-10-17","license":"MIT","archived":false,"checkedAt":"2026-10-19"}},"related":[{"slug":"claude-code","name":"Claude Code","tagline":"Terminal-first coding agent with deep repository context"},{"slug":"cursor","name":"Cursor","tagline":"The AI-first code editor that understands your codebase"},{"slug":"devin","name":"Devin","tagline":"Autonomous AI engineer for defined engineering tasks"},{"slug":"stagehand","name":"Stagehand","tagline":"AI-native browser automation that mixes code and natural language"},{"slug":"browser-use","name":"Browser Use","tagline":"Open-source framework for LLM-driven browser agents"}],"links":{"self":"/api/gems/slayer","html":"/gems/slayer","markdown":"/gems/slayer.md","category":"/api/gems?category=agents","categoryPage":"/stacks/agents"}}