Empowering Non-Technical Users with an AI-Powered SQL Editor

Navigating database querying as a non-technical growth professional in a fast-paced startup environment

March 19, 2025
Galaxy Team
Join our blog for early access to all our posts and fun updates from the team
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Working With Data Origin Story: I Didn't Love SQL

In college I was actually a CompSci major. It was a ton of fun coding and getting to solve cool problem sets / projects, but some of the classes were unbelievably difficult, and the IDEs were also frustrating to use. One of those courses was CompSci 316 - Introduction to Databases. Everyone hated this class, people dreaded the problem sets, the exams, and more. At the time, SQL really made no sense to me and I couldn't conceptualize why this was important when I could navigate datasets in Python with ease. JOINs were my arch-nemesis, and I couldn't understand why anyone would voluntarily work with databases. Fast forward to today, and I'm (somewhat actively) seeking out opportunities to query data myself.

In finance and growth equity, data was also key - every number was meticulously checked, every decision came from a model which was projected based on a number of underlying assumptions, all numerical and reasoned out.

Even when I joined my current FT role, sub 10 people, data was always the basis of every decision. Making informed product decisions, validating customer pain points, and understanding user behavior patterns aren't just buzzwords—they're the foundation of my day-to-day responsibilities. A large percentage of how I interact cross-functionally involves data querying so that I can help inform product roadmap / direction, validate customer problems, explain shortcomings / improvements to our platform, propose experiments, and more.

The Modern Data Stack: Why SQL Skills Matter Now More Than Ever

In today's hyper-competitive startup landscape, data isn't just a byproduct of our operations—it's the compass guiding our entire product development process. Having direct access to this data through SQL allows growth professionals like me to:

  • Identify usage patterns that reveal which features resonate most with users and how that impacts product roadmap
  • Validate my own problems using our product as well as that of our customers.
  • Create data-driven hypotheses for future growth experiments
  • Garner buy-in from engineers or the team in relation to projects we need to prioritize
"The great thing about fact-based decisions is that they overrule the hierarchy." Jeff Bezos

Breaking Down the SQL Learning Barrier

Learning SQL definitely isn't exactly a walk in the park, especially for those of us without technical backgrounds. The syntax can feel clunky and unintuitive. Concepts like normalization, primary keys, and query optimization can quickly overwhelm beginners.

But here's the exciting part—there's never been a better time for non-technical professionals to learn SQL. Tools like Cursor and LLMs have given non-technical users the ability to write code with the assistance of AI with more precision than ever before.

I've used Cursor for some amazing things in my normal day-job, from building CSV cleaners, to scraping websites, to interacting with APIs, to using BrowserBase, and tons more.

Some resources I've found helpful on my journey:

  1. SQLBolt: Interactive lessons that let you practice queries as you learn
  2. Codecademy's SQL Course: Structured learning path with hands-on exercises
  3. Khan Academy's SQL Module: Excellent visual explanations of SQL concepts
  4. SQLZoo: Practice-oriented learning with immediate feedback
  5. Claude and ChatGPT (obviously)
  6. Bugging my co-founders and making them pressure check my work

Democratizing Data Access: Free Querying Tools

While I don't feel any of the free tools out there are built for the future / empower me to be more technical, they can allow you to take the initial step innto the SQL pool. Almost all of these are pretty tough on the eyes. Long term, we hope to democratize data access thru use of AI and a intuitive and pretty UI / UX.

Top Free SQL Tools for Growth Professionals

pgAdmin: The Classic Open-Source Option

pgAdmin serves as an open-source administration and development platform primarily for PostgreSQL. While it's incredibly powerful, the interface is overwhelming as a beginner. However a lot of people on my team use it due to its robust functionality.

Pros:

  • Completely free and open-source
  • Comprehensive PostgreSQL management
  • Extensive documentation and community support

Cons:

  • It's only for Postgres
  • Steeper learning curve for non-technical users
  • Interface feels designed for DBAs rather than business users
  • Limited collaboration features

Redash: Visualization-Focused Querying

Redash quickly became one of my favorite tools. It connects to various data sources, allows for query writing, and—most importantly for me—creates interactive dashboards that can be shared across the organization. Because it's free, we use this for everything. It's pretty brutal in terms of UI / UX, organization, and sharing / collaboration. Also AI is nowhere to be found...

Pros:

  • Open-source with a generous free tier
  • Strong basic visualization capabilities
  • Query library for saving and reusing common queries
  • Integrates with multiple data sources beyond just PostgreSQL

Cons:

  • Self-hosted installation can be tricky for non-technical users
  • Poor UX and organization enablement
  • Visualization options aren't extensive
Equals: Spreadsheets Meet SQL Power

Equals offers a fascinating hybrid approach—combining the familiarity of spreadsheets with the power of SQL. For someone coming from an Excel background, this was a revelation. I'm a big fan of the Equals approach as well, and am friends with a handful of people on their team :)

Pros:

  • Familiar spreadsheet interface
  • Seamless blending of SQL queries with spreadsheet operations
  • Excellent collaboration features
  • Version history tracking

Cons:

  • Free tier has some limitations
  • Still relatively new compared to established options

Bridging the Gap: Non-Technical and Technical Team Collaboration

One unexpected benefit of learning SQL has been improved communication with our engineering and data teams. Speaking their language—even at a basic level—has transformed our interactions from "can you pull this data for me?" to collaborative problem-solving sessions.

Effective database query tools facilitate this collaboration through:

Shared query libraries where common analyses can be stored and accessed by anyone. We're doing this in a janky way in Redash but aim to do this more seamlessly in Galaxy's Collections feature.

We still think there's a ton of features missing from a collaborative, AI-enabled query tool, which is why we're building many of these into Galaxy ourselves :)

  1. As mentioned above, a context-aware AI copilot for query generation, auto-complete, and optimization
  2. Collaboration thru Collections (like Postman) and also real-time sharing and editing.
  3. Version control for queries, allowing teams to track changes and improvements.
  4. Access controls that ensure security while democratizing data access.
  5. Query annotations to explain complex joins or calculations for future reference
  6. Exportable results that can be shared via Slack, email, or embedded in other tools
  7. and much more down the line ;)

This collaborative approach ensures everyone operates from the same data foundation, eliminating the "multiple versions of truth" problem that plagues many organizations.

The AI-Powered Future of SQL Tooling

While the current landscape of SQL tools is impressive, the most exciting developments lie at the intersection of database querying and artificial intelligence. These innovations promise to make SQL even more accessible to non-technical users.

Creating a Better Database Querying Future

As someone who once considered SQL my academic nemesis, I'm now surprisingly passionate about creating more accessible database tooling. The next generation of query tools needs to:

  1. Lower the technical barrier without sacrificing analytical power, empowering technical users with better tools and non-technical users with the ability to become more technical!
  2. Enhance collaboration between technical and non-technical team members
  3. Leverage AI capabilities intelligently, without creating "black box" solutions
  4. Integrate seamlessly with existing workflows and communication channels
  5. Maintain enterprise-grade security while democratizing data access

The ultimate goal isn't just making SQL easier—it's transforming how entire organizations relate to their data. When everyone from marketing specialists to product managers can independently answer data questions, the pace of innovation accelerates dramatically.

The most surprising outcome has been how empowering it feels to answer my own data questions without depending on others. That autonomy has made me more effective in my role and has changed how I approach growth challenges.

Conclusion: The Data-Empowered Growth Professional

The ability to directly query databases has fundamentally transformed my effectiveness in growth. What once required a formal request to the data team can now be accomplished independently in minutes, allowing for faster iteration and more data-informed decisions.

For other non-technical professionals hesitating to dive into SQL, I offer this encouragement: the learning curve is real, but it's nowhere near as steep as it once was. Modern tools have democratized database access, and the skills you'll develop will pay dividends throughout your career.

As we look toward the future of database querying, the integration of AI capabilities promises to make these tools even more accessible while maintaining their analytical power. The combination of human curiosity with technological advancement creates a future where truly data-driven decisions are within everyone's reach—technical background or not.

What's your experience with SQL as a non-technical professional? Have you found other tools that make database querying more accessible? I'd love to hear your thoughts in the comments below!

Our v0.1-alpha is coming in April 2025.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Check out our other blog posts!

Trusted by top engineers on high-velocity teams

Aryeo Logo
Assort Health
Curri
Rubie
Comulate
Truvideo Logo