- Home
- Skills
- Research & Analysis
- Lean Research
Lean Research
Research a question through testable hypotheses, corroborated evidence, explicit gaps, and a clear conclusion.
Free
Works with the AI Agents you already use
Lean Research
Example session with this skill installed
Research whether our small team should use SQLite or Postgres for a single-region internal inventory app expected to have 20 concurrent users. Compare operational burden and concurrency. Use current documentation, cite claims, and say what would change the recommendation.
- Read your context and instructions
- Compiled the lean research
- Generated the document
Goal & hypotheses
Question: Which database fits a single-region internal inventory app with about 20 concurrent users?
- H1: SQLite is sufficient if writes are brief and serialized, with one application host accessing the database file.
- H2: Postgres is the safer default if concurrent writes, multiple application hosts, or database-level access control are expected.
Findings
- SQLite permits multiple readers, but only one writer at a time. This fits low-write workloads when transactions are short. Source: SQLite, “Appropriate Uses For SQLite,” https://www.sqlite.org/whentouse.html
- SQLite’s own guidance recommends a client/server database when many programs access the database over a network or when many concurrent writers are needed. Source: SQLite, “When To Use SQLite,” https://www.sqlite.org/whentouse.html
- PostgreSQL uses a client/server architecture and supports concurrent sessions with transaction isolation and row-level locking. Source: PostgreSQL documentation, “Concurrency Control,” https://www.postgresql.org/docs/current/mvcc.html
Contradictions & gaps
“20 concurrent users” does not establish write concurrency. Twenty people mostly reading and occasionally saving short updates can have a different load from 20 simultaneous bulk imports. Hosting topology, backup requirements, and operator experience are also unspecified. Documentation describes capabilities, not this app’s measured workload.
Conclusion
Start with SQLite if the app runs on one host, writes are short and infrequent, and the team can tolerate brief write contention. Choose Postgres if you expect multiple app hosts, frequent concurrent writes, or need a separately managed database service. Before committing, test the busiest expected workflow and confirm backups and restore procedures.
Next steps
- Measure simultaneous writes in a representative import/update test.
- Confirm whether deployment will use one application host.
- Verify backup restoration for the selected database.
whentouse.html
PDF · document
Example file from a real run - the skill writes it into your workspace.
Connects securely to your tools. The creator never sees your data.
About this skill
Lean Research turns a question into testable hypotheses, investigates relevant evidence, and corroborates claims independently where possible. It dates volatile facts, separates contradictions and unresolved gaps from findings, and stops when the question is answered or the evidence runs out. It invents no evidence and omits secrets and personal information.
Use it for focused factual questions where you need to see what was tested, what sources support the answer, and where certainty ends.
Strictly read-only. Will not provide recommendations, outside facts, or creative suggestions. Output length scales directly to source material length.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
1 use
Times used to date
Free forever
No account required to browse
Trust & safety
Security scan
Security scan passed 1 month ago
- Free with an Agensi account
Permissions
No special permissions declared or detected