Living collection
Data and analytics | Open Source Apps That Replace Paid Software
23 resourcesOrganized by use
Data and analytics
Data and analytics
3 resourcesFull profiles and sources
Public APIs / Datasets repository
Library
Finding free public APIs organized by category for integration into software projects
Community directory of hundreds of free public APIs organized by category, for developers looking for data sources for their projects.
Why it belongs here. It gathers hundreds of public APIs by category and lets you shortlist candidates by authentication, HTTPS and CORS before checking each provider.
Its limit. Quotas, stability, pricing and production readiness are not documented consistently; the repository's MIT license does not cover the terms of the linked APIs.
In plain English: a huge, organized list for finding an API that supplies data to a project. You still need to check whether that API is reliable and what it costs.
Compatibility and setupRequirements and agent differences
Compatibility. The repository classifies entries by authentication, HTTPS and CORS. Requirements vary by provider; a shared account and key apply only to APILayer's own suite.
Real cost and licenseResource, agent and extra costs
Cost. The repository is open source under the MIT license. Each API has its own pricing and limits; the dossier supplies no euro prices or verifiable official conversion.
Example and alternativeWhen it helps and what else to use
Example. Choose an API listed as requiring no authentication and supporting HTTPS and CORS, confirm those details in its documentation and make a minimal request before integrating it.
Alternative. Search Google for public APIs manually and check each provider's documentation directly.
Sources and reviewWhat is documented and what was tested
Review. Entry checked on 27 September 2026 against the repository, README and APILayer website; no personal test by Dani is recorded.
Official repository ↗APILayer website ↗Official Postman collection ↗
Resource detailsEditorial profile and links
- Replaces: manually searching Google for public APIs
- Deployment: web
- Watch out: A static curated Markdown list; entries can be outdated or contain broken links because it relies on community contributions
Graphic Walker
Library
Sources checked: 21 Sep 2026
Embedding interactive Tableau-style data visualization in your own apps without depending on heavy BI platforms
Open source visual analytics component with drag-and-drop controls, embedded in web apps or Python notebooks as a lightweight alternative to Tableau.
Why it belongs here. It adds drag-and-drop visual exploration to a React application without requiring a monolithic business intelligence platform from the outset.
Its limit. Real integration requires development, data preparation, permissions and your own Spanish translation. The dossier does not establish performance at large data volumes or supply enterprise prices officially converted to euros.
In plain English: feed it data and build charts by dragging columns with your mouse, either in the web version or inside your own React application.
Compatibility and setupRequirements and agent differences
Compatibility. Works on the web, as an embeddable React component and in self-hosted installations. It can compute in the browser through Web Workers or delegate queries to external infrastructure; Spanish requires custom i18n resources.
Real cost and licenseResource, agent and extra costs
Cost. The project uses Apache-2.0 and lists no fee for the open source package. Hosting, development and enterprise services cost extra; no price is published here without an official, dated euro conversion.
Example and alternativeWhen it helps and what else to use
Example. Embed a view in an internal application to explore spend and conversions by channel and date. This is a proposed use case, not a personal test.
Alternative. Tableau is the stated alternative, but it offers a broader platform. Compare connectors, governance and collaboration before treating the two as interchangeable.
Sources and reviewWhat is documented and what was tested
Review. Entry checked on 2 October 2026 against the repository, official website and primary documentation; no personal test or rating is attributed to Dani.
Resource detailsEditorial profile and links
- Replaces: Tableau
- Deployment: web, extension
- Platforms: React, JavaScript/TypeScript, Python (PyGWalker)
- Watch out: An embeddable component, not a complete BI platform: data source and user management have to be integrated separately
ChartDB
App
Sources checked: 6 Sep 2026
Visualizing and designing database schemas by importing them with a single query
Database diagram editor that imports your schema with a query, lets you edit it visually, export DDL or migrate between SQL dialects with AI.
Best for: Visualizing and designing database schemas by importing them with a single query
Resource detailsEditorial profile and links
- Replaces: DrawSQL, dbdiagram.io, SQLDBM
- Deployment: web, self-hosted
- Platforms: PostgreSQL, MySQL, SQL Server, SQLite, MariaDB, ClickHouse, CockroachDB, Oracle, Snowflake, BigQuery
- Watch out: AI export features require an OpenAI key or your own inference server