How do I filter by specific file types?

You can use standard SQL WHERE clauses on the 'lang' column in the Files view, for example: WHERE lang = 'typescript'.

Does it support semantic search?

Yes, the skill includes a search() function that provides a hybrid of semantic and lexical search to find code concepts rather than just exact strings.

RepoQL SQL is a specialized skill for Claude Code that allows you to query your repository's structure and metadata using DuckDB SQL syntax.

Can I use this to find errors in my code?

Yes, you can use the Annotations and Files views to query for parse errors, linting results, and specific diagnostic messages across your project.

RepoQL SQL Reference

Name: RepoQL SQL Reference
Author: stueeey

bystueeey

0•

Database Management

Queries repository metadata and code structures using DuckDB SQL to gain deep insights into codebase architecture and health.

The RepoQL SQL skill empowers Claude to perform advanced, relational queries against a code repository's indexed data. By leveraging core views such as Files, Functions, Types, and Annotations, users can programmatically identify code patterns, track technical debt via error counts, and perform hybrid semantic-lexical searches. This skill is essential for developers needing a structured way to audit large codebases, map dependencies, or find specific code snippets using precise SQL syntax instead of manual exploration.

Key Features

01Relational querying of file metadata, language stats, and line counts

020 GitHub stars

03Hybrid semantic and lexical search capabilities for intelligent code discovery

04Deep inspection of function signatures, types, and class hierarchies

05Real-time diagnostic analysis through an Annotations view for error tracking

06Context-aware code snippet retrieval based on URI and location

Use Cases

01Auditing large repositories to identify files with the highest error counts or line complexity

02Mapping class hierarchies and interface implementations across a multi-service project

03Locating specific asynchronous methods or patterns within a scoped directory using SQL filters

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add stueeey/repoql.public repoql-sql

For use in Claude.ai and ChatGPT

Download Skill