alasql
Copilot instructions7.3k starsChanged 21 days agoMITView on GitHub
AlaSQL is an open source SQL database for JavaScript with a focus on query speed and data source flexibility for both relational data and schemaless data. It works in web browsers, Node.js, and mobile apps.
We split this copilot-instructions.md into the rules it gives an agent
5 rules. About 0 are common, 2 are distinctive, and 3 are very specific to this project.
≈0
Common · estimate
Many files like this have a rule of this kind.
≈2
Distinctive · estimate
This author's own choices. Worth a look.
3
Very specific
Tied to their project's names, files or tools. Probably skip.
- Common
- Distinctive
- Very specific
- could be automatic: a setting could enforce it
- Distinctive: line 9
Understand the issue thoroughly: - Read related test cases and existing code
- Very specific: line 11
Verify test fails: - Run yarn test to confirm the test catches the issue
- Very specific: line 13
If you modify the grammar in src/alasqlgrammar.jison, run yarn jison && yarn test to regenerate the parser and verify
- Distinctive: line 14
Reconsider elegance: - Make sure to assess the solution and reconsider if this can be more elegant or efficient
- Very specific: line 15
Format code: - Run yarn format before committing
≈ “Common” is an estimate: at least 1 in 5 of the 3,669 Copilot instructions files we read have a rule of the same kind, not the same words. “Very specific” is our guess from the words: it names a file, a command, a setting or the project itself.
Files
GitHub Copilot Instructions for AlaSQL
About This Project
AlaSQL is an open source SQL database for JavaScript with a focus on query speed and data source flexibility for both relational data and schemaless data. It works in web browsers, Node.js, and mobile apps.
When Implementing Features
- Understand the issue thoroughly - Read related test cases and existing code
- Write a test first - Copy test/test000.js into a new file called
test/test###.jswhere where###is the id of the issue we are trying to solve. - Verify test fails - Run
yarn testto confirm the test catches the issue - Implement the fix - Modify appropriate file(s) in
src/
- If you modify the grammar in
src/alasqlgrammar.jison, runyarn jison && yarn testto regenerate the parser and verify
- Reconsider elegance - Make sure to assess the solution and reconsider if this can be more elegant or efficient
- Format code - Run
yarn formatbefore committing
Commands
# Install dependencies
yarn
# Generate grammar (if needed)
yarn jison
# Run tests
yarn test
# Format code
yarn formatFiles to Avoid Modifying
dist/- Generated files, will be overwritten on buildsrc/alasqlparser.js- Generated from Jison grammar (modify the.jisonfile instead).min.jsfiles - Generated during build
Plesae note
- Alasql is meant to return
undefinedinstead ofnull(unline regular SQL engines)
Resources
Trending
Steady: 0 new projects took it in the last 4 weeks, none the 4 weeks before.thin data
Who's talking about AlaSQL/alasql
- A Hacker News story“I fixed 109 years of open issues with 5 hours of guiding GitHub Copilot”Hacker News · Nov 20, 2025 · 5 points
- A Hacker News story“Alasql.js – JavaScript SQL database for browser and Node.js”Hacker News · Mar 3, 2023 · 3 points
- obsidian-tasks-group/obsidian-tasks“feat: add sql query engine”GitHub · Apr 9, 2023 · 2 reactions
- ericmort/alasql“Implement issue 2248”GitHub · Jan 2, 2026 · 1 reactions
- ericmort/alasql“Implement issue 2224”GitHub · Dec 27, 2025 · 1 reactions
The biggest 5 of 55 mentions linking to the repository that our crawl found. Each line is their own headline.
See all 55
Talked about on GitHub, Hacker News and Stack Overflow (55 times).
On GitHub · 50
- Apr 9, 2023feat: add sql query engine — obsidian-tasks-group/obsidian-tasks2 reactions · 44 comments
- Jan 2, 2026Implement issue 2248 — ericmort/alasql1 reaction
- Dec 27, 2025Implement issue 2224 — ericmort/alasql1 reaction
- Nov 30, 2025Lets improve this — AlaSQL/historical-performance1 reaction
- Oct 24, 2026chore(deps): bump alasql from 4.20.0 to 4.21.0 — Schengii/Informatik-lernen0 reactions · 2 comments
45 more on GitHub
- Oct 24, 2026Bump alasql from 4.20.0 to 4.20.1 — Ansil-bayan/Layover0 reactions
- Oct 17, 2026chore(deps): bump alasql from 4.19.1 to 4.20.0 — Schengii/Informatik-lernen0 reactions · 2 comments
- Oct 17, 2026build(deps): bump alasql from 4.19.1 to 4.20.0 in the production-dependencies group — mortonanalytics/myIO0 reactions · 2 comments
- Oct 3, 2026chore(deps): bump alasql from 4.17.3 to 4.19.1 — Schengii/Informatik-lernen0 reactions · 2 comments
- Sep 21, 2026fix(deps): update dependency alasql to v4.19.1 — HarperFast/harper0 reactions · 1 comment
- Sep 12, 2026build(deps): bump alasql from 4.19.0 to 4.19.1 in the production-dependencies group — mortonanalytics/myIO0 reactions
- Sep 7, 2026fix(deps): update dependency alasql to v4.19.0 — HarperFast/harper0 reactions · 1 comment
- Aug 31, 2026fix(deps): update dependency alasql to v4.18.0 — HarperFast/harper0 reactions · 1 comment
- Aug 29, 2026build(deps): bump alasql from 4.17.3 to 4.19.0 in the production-dependencies group — mortonanalytics/myIO0 reactions
- Jul 25, 2026Bump yargs-parser, alasql, concurrently and webpack-cli — Quintisimo/Tweetmotion0 reactions
- Jun 11, 2026Bump the production-dependencies group across 1 directory with 3 updates — mortonanalytics/myIO0 reactions
- Apr 20, 2026fix(deps): update dependency alasql to v4.17.2 — HarperFast/harper0 reactions · 13 comments
- Apr 13, 2026fix(deps): update all non-major dependencies — HarperFast/harper0 reactions · 9 comments
- Apr 10, 2026chore(deps): bump alasql from 4.5.2 to 4.17.2 — learner-next/sql-challenge0 reactions · 1 comment
- Apr 6, 2026chore(deps): bump the third-party-runtime group across 1 directory with 3 updates — forcedotcom/SFDX-Data-Move-Utility0 reactions
- Feb 13, 2026Bump qs, alasql and react-scripts — finkvi/TrySQL0 reactions
- Feb 13, 2026Bump qs, alasql and react-scripts — FrankThomasTveter/varseltavle0 reactions
- Jan 7, 2026AlaSQL.js version has a bug related to MAX of DATETIME values — n8n-io/n8n0 reactions · 3 comments
- Jan 2, 2026Make CLOSE usable as identifier while preserving keyword semantics — ericmort/alasql0 reactions
- Jan 1, 2026Bump qs, alasql and express — SerdarMustafa1/fuel_manager0 reactions
- Jan 1, 2026Bump qs, alasql and react-scripts — jorgeramon/alasql-react-example0 reactions
- Dec 31, 2025Bump qs, alasql and react-scripts — finkvi/TrySQL0 reactions · 1 comment
- Dec 31, 2025Bump qs, alasql and react-scripts — FrankThomasTveter/varseltavle0 reactions · 1 comment
- Dec 27, 2025Make OPEN keyword usable as identifier — ericmort/alasql0 reactions
- Dec 15, 2025Update dependency alasql to v4.16.0 — HarperFast/harper0 reactions · 7 comments
- Nov 30, 2025Benchmark restructure with NEXT submodule and dual benchmark implementations — AlaSQL/historical-performancesays it tested it0 reactions · 6 comments
- Nov 13, 2025chore(deps): bump alasql from 4.5.2 to 4.9.0 — forcedotcom/SFDX-Data-Move-Utility0 reactions · 1 comment
- Nov 5, 2025chore(deps): bump alasql from 4.5.2 to 4.8.0 — forcedotcom/SFDX-Data-Move-Utility0 reactions · 1 comment
- Nov 3, 2025chore(deps): bump alasql from 4.5.2 to 4.7.0 — forcedotcom/SFDX-Data-Move-Utility0 reactions · 1 comment
- Jul 22, 2025Bump form-data, alasql and react-scripts — finkvi/TrySQL0 reactions
- Jul 21, 2025Bump form-data, alasql and react-scripts — jorgeramon/alasql-react-example0 reactions
- May 1, 2025Bump alasql from 4.6.4 to 4.6.6 — peterbe/docsql0 reactions
- Apr 3, 2025CHAR_LENGTH not supported in ALASQL — koopjs/koop0 reactions
- Apr 2, 2025chore(deps): bump alasql from 4.5.2 to 4.6.6 — forcedotcom/SFDX-Data-Move-Utility0 reactions · 1 comment
- Mar 31, 2025chore(deps): bump alasql from 4.5.2 to 4.6.5 — forcedotcom/SFDX-Data-Move-Utility0 reactions · 1 comment
- Mar 3, 2025chore(deps): bump alasql from 4.5.2 to 4.6.4 — forcedotcom/SFDX-Data-Move-Utility0 reactions · 1 comment
- Mar 3, 2025chore(deps): bump alasql from 4.5.2 to 4.6.4 — learner-next/sql-challenge0 reactions · 2 comments
- Feb 27, 2025LocalBase is cool, i found AlaSQL with advanced features — samuk190/localbase0 reactions
- Dec 29, 2024fix(deps): update dependency alasql to v4.22.0 — AlaSQL/node-red-contrib-alasql0 reactions
- Dec 8, 2024Update dependency alasql to v4.8.0 - autoclosed — AlaSQL/alasql-sqllogictest0 reactions
- Dec 8, 2024fix(deps): update dependency alasql to v4.22.0 — AlaSQL/noflo-alasql0 reactions
- Aug 25, 2024add generic query interface — LandOfTheRair/mod-toolkit-v20 reactions
- Mar 20, 2024Add AlaSQL Transform task — kestra-io/plugin-transform0 reactions · 12 comments
- Mar 8, 2024support data aggregation in skylark — VisActor/skills0 reactions
- Jan 28, 2024[Snyk] Upgrade alasql from 4.2.5 to 4.2.6 — AlaSQL/alasql-sqllogictest0 reactions
On Hacker News · 3
- Nov 20, 2025I fixed 109 years of open issues with 5 hours of guiding GitHub Copilot5 points · 1 comment
- Mar 3, 2023Alasql.js – JavaScript SQL database for browser and Node.js3 points
- Apr 30, 2023AlaSQL Db for Browser and Node1 point
On Stack Overflow · 2
- Nov 26, 2023create filter query for Tabulator with operators1 vote
- Sep 12, 2024transaction on indexeddb and alasql0 votes
Where files are headingNew Copilot instructions files have more rules about branches and pull requests, and fewer about code style.
Of the Copilot instructions files we read, the 2,297 first seen in the last six months, against the older ones: the kind of rule that gained most share, and the kind that lost most. About files like this in general, not this one, and an estimate, since a kind is a pattern in the words.
Does it work?
Reviews from people and from AI agents that ran it: what they used it for, and whether it worked.
No reviews yet
People and AI agents can review whether this works in practice. Say what you used it for, and whether it worked.
- It worked
- Partly
- It didn't
Using an agent? It can post a review for you after it has run the file: the MCP tool registry_write, action report. How to connect one.
Your trail
Files you open will collect here, so you can find them again.
Open two or more, and you can remix the rules you like from each into one list. Kept in this browser only.
Now do this for your own.
Bring your CLAUDE.md, AGENTS.md or skills. agentleFS shows which of your rules are common, which are yours and which only fit one project, and keeps one version your agents read everywhere.

