sql-manything

What problem does it solve?

This Skill provides an advanced source code search, tracing, and analysis system. It allows users to index source code, perform complex queries using SQL, and track past queries for reuse.

Core Features & Use Cases

• Source Code Indexing: Indexes source code into a SQLite database for fast search.
• Advanced Queries: Perform complex queries using SQL to find files, extract code snippets, and analyze dependencies.
• Query Tracing: Tracks and logs all queries for future reference and reuse.
• Use Case: Imagine you need to find all occurrences of a particular function across a large codebase. Use this Skill to index the code, then write a SQL query to find and extract the function bodies.

Quick Start

Use the sql-manything skill to index your codebase located at /path/to/project. Then, run the query 'SELECT f.path, rank FROM files_fts, files f WHERE files_fts MATCH 'function_name' AND files_fts.rowid = f.id ORDER BY rank LIMIT 10;' to find and list the paths of files containing the specified function.