发现优质的 AI Agent 技能
聚合 Claude Skills、LangChain、AutoGPT 等优质资源,助力开发者快速构建智能应用
SQL Optimization Patterns for Dune
1. [CTE Optimization](#cte-optimization) 2. [JOIN Strategies](#join-strategies) 3. [Array Operations](#array-operations) 4. [Aggregation Patterns](#aggregation-patterns) 5. [Partition Pruning](#partition-pruning)
SQL Writer
Nobody memorizes SQL syntax. You know what data you want, you just can't remember if it's LEFT JOIN or INNER JOIN or whether the WHERE clause goes before GROUP BY. This tool takes plain English and gives you the exact SQL query you need.
SQL Injection Scanner
SQL injection has been around for decades and it's still in the OWASP Top 10. This tool scans your backend code for unsafe query construction, string concatenation in SQL, and missing parameterized queries. It finds the vulnerabilities and shows you how to fix them.
Schema Writer
Designing database tables by hand is tedious. You know what columns you need, you know the relationships, but writing out CREATE TABLE statements with proper types, constraints, and indexes takes forever. Describe your data model in plain English and this tool writes the SQL for you. Supports PostgreSQL, MySQL, and SQLite.
Query Optimizer
Slow queries killing your app? Paste your SQL or Prisma code and get optimization suggestions. Index recommendations, query rewrites, N+1 detection. The stuff that takes hours to figure out manually.
SQL Checker
Paste your SQL, get performance tips and security warnings. Catches N+1s and injection risks.
SQL Generator
Describe what you want, get the SQL. Works with any database.
Schema Generator
Describe your data, get a proper database schema. Supports SQL, Prisma, and Drizzle.
Web3 Data Explorer (Chainbase)
Query on-chain data via Chainbase Web3 API and SQL API.
Todo Management
A per-workspace SQLite database: - Default: `./todo.db` - Override: `TODO_DB=/path/to/todo.db`
Todo Management
A per-workspace SQLite database: - Default: `./todo.db` - Override: `TODO_DB=/path/to/todo.db`