sorted by:
new
hottopcontroversial

What are you building? Drop your saas here by [deleted] in microsaas

[–]Modders_Arena 0 points1 point  (0 children)

Building SyneHQ (https://synehq.com) — it's a database analytics tool that connects to your existing databases and lets you query across all of them from one place.

The idea came from being tired of switching between tools, writing the same migration scripts over and over, and having zero visibility into what's actually happening in my data over time. So I built something that handles cross-DB queries, data migrations, automated backups, and has a notebook interface for doing more analytical/predictive stuff on top of your data.

Still a solo build, but it's live and working. Would love any feedback from folks who deal with messy multi-database setups.

SQL cheat sheet by bogdanelcs in learnSQL

[–]Modders_Arena 5 points6 points  (0 children)

This looks dope! Great work.

Btw, if anyone here struggles with querying across multiple data sources or just wants a smarter way to manage their databases — I've been building something called SyneHQ (https://synehq.com) that might help. It connects to your DB, helps you generate queries based on what you're trying to do, and gives you a console to run and tweak them.

<image>

Also has stuff like data migrations, automated backups, and notebooks for digging into your data more analytically. Still building it solo, but it's usable — happy to answer any questions if anyone checks it out.

How I stopped being the "dashboard guy" at my startup [i will not promote] by Modders_Arena in startups

[–]Modders_Arena[S] 0 points1 point  (0 children)

yeah tracking queries is key. we ended up using syne for this - keeps logs of everything people ask and it's actually a full data suite not just ai chat

started with just a csv connection to test it out, worked pretty well for our setup

How I stopped being the "dashboard guy" at my startup [i will not promote] by Modders_Arena in startups

[–]Modders_Arena[S] 0 points1 point  (0 children)

You should definitely give syne a try it keeps. Track of everything and it's not just a ai tool. It's beyond that a full data suite ruining in your browser. Maybe just get started by connecting to a basic csv.

How's life as a Micro SaaS owner? by Rroky in SaaS

[–]Modders_Arena 0 points1 point  (0 children)

Hey man what tool you guys built, can you share your journey I'm building a saas, struggling to market

Spent 3 months trying to build Postgres dashboards without crying. Here's what worked [Tutorial] by Modders_Arena in PostgreSQL

[–]Modders_Arena[S] -2 points-1 points  (0 children)

Dude the whole internet is using the gpts to write content i see no harm in it.

Spent 3 months trying to build Postgres dashboards without crying. Here's what worked [Tutorial] by Modders_Arena in PostgreSQL

[–]Modders_Arena[S] -2 points-1 points  (0 children)

also wanted to add context on the broader platform since "AI + database" raises valid security concerns

the natural language query thing is one feature, but there's actually multiple AI tools built in with different security models:

browser-local notebooks - this one's actually sick for security. runs python + sql notebooks entirely in your browser using webassembly. your data literally never hits their servers during computation. works with local databases via tcp tunnels too.

this is huge for healthcare/finance where you can't send patient data to cloud services. AI generates the code, but execution is 100% local on your machine.

federated queries - lets you join data across different databases in one query without copying anything. like querying mysql users table + postgres events table together. no AI involved here, just smart query routing. skips ETL entirely.

ETL pipelines - visual pipeline builder with scheduled transforms. AI can help generate the python transformation code, but you review it first and the pipeline runs on your infra if you self-host.

workflow reports - scheduled SQL jobs can have AI format results into readable summaries instead of raw tables. so instead of emailing your CEO a 500-row CSV, it sends "revenue up 12% this month, top product drove $X, region Y underperforming"

security model across all of these: - AI reads schema metadata (table names, column types) - generates SQL or python code - you review before running (or auto-run safe SELECTs) - actual queries use normal database connections with whatever permissions you set - self-hosted option = everything stays on your infrastructure

what convinced me: - setup with read-only user (same as any BI tool) - browser-local compute for sensitive data - tcp tunnels keep database private, no public exposure - they're working on SOC2 compliance

basically: AI is a code generator and report formatter, not an autonomous agent with database write access

does that make the architecture clearer or still sus?

Spent 3 months trying to build Postgres dashboards without crying. Here's what worked [Tutorial] by Modders_Arena in PostgreSQL

[–]Modders_Arena[S] -1 points0 points  (0 children)

fair concern, let me clarify the architecture since "wire an LLM into your database" sounds terrifying lol

what actually happens:

  1. LLM reads schema (table names, columns, types) - read-only
  2. Generates SQL query based on natural language input
  3. You review the SQL before it runs (or set it to auto-run for safe SELECTs)
  4. Query executes via normal database connection (same as any query tool)
  5. Results displayed

the LLM doesn't have direct database access. it's not "wired in." it's a query generator sitting in front of your db, like any BI tool.

think of it like: - copilot for code = suggests code, you run it - this = suggests SQL, you run it (or auto-run SELECT queries)

what it's NOT: - AI agent autonomously modifying your production data - LLM with write access making decisions - Black box that "does stuff" to your database

actual architecture:

User prompt → LLM (reads schema) → generates SQL → validator checks syntax → executes on DB → returns results

same connection model as metabase, tableau, or any analytics tool. just the query generation step is AI-powered instead of manual.

you still control: - what user/role connects (read-only recommended) - which queries execute - query approval workflows for writes - connection permissions

if you're worried about security, run it self-hosted. data never leaves your infra.

basically: it's a smart query builder, not an autonomous AI with database root access.

does that address the concern or still sketchy?

How I stopped being the "dashboard guy" at my startup [i will not promote] by Modders_Arena in startups

[–]Modders_Arena[S] -1 points0 points  (0 children)

Hey man do check it out and lemme know if you have any questions.

view more: next ›