Indexes source code into SQLite and extracts snippets via SQL+FTS5 searches.
npx skills add https://github.com/IOchair/SQL-ManyThing --skill sql-manything
Please help me install this Agent Skill. Skill: sql-manything Source: https://github.com/IOchair/SQL-ManyThing/tree/main Command: npx skills add https://github.com/IOchair/SQL-ManyThing --skill sql-manything
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.
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.
High-intent search queries and answers about installing and using this skill.
You can search and extract source code snippets using SQL by indexing the codebase into an SQLite database and executing queries with an FTS5 trigram tokenizer to find specific files and function bodies.
Tracing and reusing source code queries for debugging is done by logging all executed SQL queries during codebase analysis, allowing you to track and rerun past searches for future reference.
Yes, you can use SQLite to analyze codebase dependencies by indexing the source code and performing complex SQL queries to find files and extract specific code snippets.
Yes, an FTS5 trigram tokenizer is required for the SQLite index to perform A* search and effectively extract specific code snippets during codebase exploration.
To find all occurrences of a specific function, index your project directory into the SQLite database and run a SQL query matching the function name against the indexed files to list the file paths.
sql-manything optionally uses Python scripts for additional data enrichment during source code indexing and codebase analysis, though the core SQL search functions independently.
trevorbyrumInitialize an SQLite artifact store with FTS5 and required directories.
dthompsonflRetrieve current VS Code search view results via the getSearchResults command.
butttonsQuery a SQLite-indexed codebase for symbol references and dependency analysis.
CuriousLearnerEnhances searches with semantic parsing, regex, AST code intelligence, and natural language filtering.
