Documentation Portals & DevPortals
4.0/5.0
VerifiedFreeLast technical review:
Markdown for AI (.md)

Query the Murder

Learn SQL by solving murder mysteries based on Agatha Christie novels.

Pricing

$0/mo

Free
Score

4.0/5

Last technical review
2026-11-06
Available plansVisit website (opens in a new tab)

Technical Overview

Query the Murder is a free, browser-based interactive platform to learn and practice SQL by solving murder mystery cases inspired by Agatha Christie. Users write real queries against databases of suspects, alibis, and evidence. It features 18 progressive cases from basic SELECT queries to advanced window functions, requiring no installation or account creation. The tool uses client-side database technology to process SQL statements securely and privately directly in the user's browser, making it an ideal choice for educators and developers looking for hands-on SQL practice.

Analyst Evaluation: Pros and Limitations

Verified Advantages

  • Completely free with no account registration required.
  • Unique practical approach based on real mystery cases.
  • Pedagogical progression from basic SELECT queries to advanced functions.

Technical Considerations

  • Lacks enterprise features such as user management or SSO.
  • Content is limited to the 18 pre-built Agatha Christie inspired cases.

Technical Capabilities & Features

3/7
Included:REST & GraphQL API
Not available:SSO / SAML Authentication
Included:Self-Hosted Option
Included:Full Data Export
Not available:Role-Based Access Control (RBAC)
Not available:Custom Domains & SSL
Not available:Immutable Audit Logs
Scorecard
Show detailsHide details

Technical Scorecard: Query the Murder

72/100
DX & Tech Documentation
Favorable
77/100
Pricing Fairness
Excellent
83/100
Security & Governance
Favorable
64/100
Data Portability & Sovereignty
Improvable
58/100
Performance & Reliability
Favorable
76/100
Pricing & TCO
Show detailsHide details

Pricing

$0.00/mo

Model: FREE.

Free Tier Verification:

  • No credit card required
  • Commercial use allowed
  • Unlimited usage with no expiration
  • No mandatory watermarks
Get Query the Murder (opens in a new tab)
Total Cost of Ownership (TCO) Projection: Query the Murder$0.00/mo
Deterministic cost estimation at 12 and 36 months based on team size, including SSO tax premiums and annual prepay discounts.
Show detailsHide details
Licensing Cost (1 to 100+ seats)
$0/forever
Unlimited team members with zero penalties
SSO Tax (SAML Enterprise)
$0no surcharge
No artificial security barriers
3-Year Investment (Software TCO)
$0total
operates under a zero-cost or open-source model. Licensing TCO is identical:
Usage Surcharges & Bill Shock Simulator: Query the MurderWhat usage costs as you scale
Detect overage penalties before they impact engineering budget.
Show detailsHide details

Prototype / MVP (10 GB)

Included base quota in plan: 10 GB.
Low Risk / Predictable Bill
Base Monthly Rate
$0/mo
Fixed subscription or contracted tier
Overage Penalty
$0/month extra
Usage covered within plan quota
Estimated Monthly Invoice
$0/mo
Total monthly cost before taxes
Technical Mitigation Recommendation:

Suitable for development; verify concurrent connection limits.

Base Production (50 GB)

Included base quota in plan: 50 GB.
Low Risk / Predictable Bill
Base Monthly Rate
$0/mo
Fixed subscription or contracted tier
Overage Penalty
$0/month extra
Usage covered within plan quota
Estimated Monthly Invoice
$0/mo
Total monthly cost before taxes
Technical Mitigation Recommendation:

Implement table compression policies and temporal partitioning.

Active Growth (250 GB)

Included base quota in plan: 250 GB.
Low Risk / Predictable Bill
Base Monthly Rate
$0/mo
Fixed subscription or contracted tier
Overage Penalty
$0/month extra
Usage covered within plan quota
Estimated Monthly Invoice
$0/mo
Total monthly cost before taxes
Technical Mitigation Recommendation:

Offload cold backups to standard object storage (S3).

Large Scale (1.000 GB (1 TB))

Included base quota in plan: 1,000 GB.
Low Risk / Predictable Bill
Base Monthly Rate
$0/mo
Fixed subscription or contracted tier
Overage Penalty
$0/month extra
Usage covered within plan quota
Estimated Monthly Invoice
$0/mo
Total monthly cost before taxes
Technical Mitigation Recommendation:

Migrate to dedicated instance or self-hosted cluster to curtail I/O fees.

Security & Data Exit
Show detailsHide details

Compliance & Security Standards: Query the Murder

SOC 2 Type IINot reported
ISO 27001Not reported
GDPR / RGPDNot reported
HIPAANot reported
PCI-DSSNot reported
Jurisdiction & Legal Sovereignty
🇺🇸United States [US]Subject to US CLOUD ActGDPR DPA Available
SSO Availability (SAML Enterprise)
No SSO Documented
Data Residency
SELF_HOSTEDEUUSAWS
AI Privacy Policy
Not evaluated
Data Liberation & Migration Runbook: Query the MurderPG_DUMP · JSON · CSV
Actionable escape runbook and credential export guarantees to mitigate vendor lock-in.
Show detailsHide details
Supported Structured Export Formats
PG_DUMPJSONCSVPARQUET
Password Hash Portability
Exportable Hashes (Bcrypt / Argon2): Zero Forced Retention

Allows extracting password hashes in standard formats to migrate without forcing user resets.

CLI Command / Rescue Endpoint
docker exec -t query-the-murder pg_dump -U postgres > backup.sql
Exit Protocol & Migration Notes

Direct database-level export without proprietary password encryption.

Deployment & Infrastructure Requirements: Query the MurderDocker
Hardware specs and Docker directives to run on local servers, dedicated VPS, or Kubernetes without telemetry leak to the cloud.
Show detailsHide details
Minimum Memory1 GB RAM (Recommended)
Compute CPU1 vCPU
Runtime / LanguageTypeScript / Go / Rust
Code LicenseOpen Source
Docker CLI Directive
docker run -d --name query-the-murder -p 8080:8080 query-the-murder:latest
Companion Services & Dependencies:
PostgreSQL 15+Redis 7+
Community & Repository
Show detailsHide details

Technical Reputation of Query the Murder

82/100 Technical Trust

Frequent Praises in Production

  • Completely free with no account registration required.
  • Unique practical approach based on real mystery cases.
  • Pedagogical progression from basic SELECT queries to advanced functions.

Reported Production Frictions

  • Lacks enterprise features such as user management or SSO.
  • Content is limited to the 18 pre-built Agatha Christie inspired cases.
Commercial Treatment & Vendor Lock-in:1-Click Cancellation

Immediate cancellation from account settings without phone calls or forced retention.

Frequently Asked Technical Questions (Query the Murder)

Do I need to install any software to use Query the Murder?

No software installation or database management system is required. The application runs entirely within your web browser with instant query execution.

Is an account or subscription required to access the cases?

Access is completely free and open. No account registration, email address, or subscription payment is required to solve the cases.

What SQL skill level is required to get started?

The early cases are specifically designed for absolute beginners, starting with basic SELECT and WHERE clauses, and gradually advancing to complex joins.

Direct Alternatives

All tools in Query the Murder
Embed Verification Badge
Official Badge
Show detailsHide details
TheJudex Verified - Query the Murder