Show HN: Open-source, self-hosted data management app and internal tool builder
Hey HN, This is Adrian and David, and we're excited (and nervous) to show you basetool (https://basetool.io). Basetool helps companies view and manage all their data in one place.

Companies have data in tons of places like BI tools, data warehouses, 3rd party services, and their databases. However, because the tools are not connected, it's a hassle to have visibility across the whole organization and even more difficult to safely share that data with the team or external collaborators.

The vision is to give basetool access to your data source and get a tool that way above a database client. You get an app that's more than an admin panel but somewhere around an internal tool tailored to your needs. The app can be configured visually (no more engineering bottlenecks) and ready to be used by your end-users like teammates and external collaborators. You can easily curate the data you want to show and assign it to your stakeholders.

We are aware everyone has questions about data security. We know how important security is to you. That's why we're offering the self-hosted version from the get-go. Use it on your infrastructure close to your data.

By default, basetool doesn't store any of your data, and it's straightforward to disable tables and fields that are not meant to be seen or contain PII (they never leave the server). In addition, with a role-based access control system and custom filters based view system, you can control who can see what type of data.

The second-most troubling issue with these kinds of tools is around data safety. "You don't directly edit production data". We know how vital data safety is, so we're shipping with validation rules in place from day one. Standard validation rules are in place (required, read-only, nullable, defaults, etc.), with more stringent rules coming shortly.

The third big problem we're tackling is showing the data in a meaningful way. We don't just want to display a table with your records. We want to help you curate what's essential in an intuitive way. We have some very cool updates coming your way to allow that even better.

We're nerds, so we built this as an open-source project. We want to give something back to the fantastic OSS community and want to open up basetool so anyone can contribute and help improve the ecosystem. The fields and data sources are totally pluggable, so you can bring your own.

Basetool is written in TypeScript and (in our opinion) with most modern pieces of tech out there; React, Redux toolkit, Next.js, Prisma, and tailwindcss. We want this to be a project that lives on in the future.

We also want to build a business that funds the further development of products like basetool. This is why we're offering a cloud version that will eventually have paid tiers. https://basetool.io wants to be your one-stop shop where you go from credentials to an admin panel in less than 60 seconds.

We built this in about ten weeks, so there might still be some rough edges, but we're here to polish them.

We made a short demo video this morning. https://www.loom.com/share/b8f40183134445208c121128d11b12d9

We'd love to hear about any feedback, ideas, or questions you might have about what we're building!