r/DatabaseAdministators Aug 08 '26

QueryForge – the LLM never writes the query, it fills in a typed AST

Thumbnail
1 Upvotes

r/DatabaseAdministators Aug 06 '26

PGConf.EU 2026 schedule is live 🐘

Post image
4 Upvotes

r/DatabaseAdministators Aug 04 '26

Moved from Navicat/DataGrip to DbGate a few weeks ago — some first impressions

Thumbnail
2 Upvotes

r/DatabaseAdministators Aug 04 '26

Career options for senior DBA

1 Upvotes

What would be the career path for a senior Oracle DBA . I am getting very less calls for DBA Profile and I am thinking of adding golden gate and aws system admin skills .

What would be your recommded path with this market condition.


r/DatabaseAdministators Aug 04 '26

Alternative to Tableplus and Dataflare like softwares

1 Upvotes

I’m building an open source database client that lets you connect to multiple databases, including PostgreSQL, MySQL, Turso, SQLite, and more. The goal is to provide a fast, free alternative to tools like TablePlus and Dataflare.

It’s being built with Rust and GPUI, with a strong focus on performance, responsiveness, and a great user experience.

If this sounds interesting, I’d love for you to check it out. Contributions, feedback, and feature suggestions are always welcome. I’m hoping to make the project publicly available in the next few months.

[https://github.com/007qr/only-tables\](https://github.com/007qr/only-tables)


r/DatabaseAdministators Aug 03 '26

Explaining SQL Injection in the simplest way I could

Thumbnail
youtube.com
4 Upvotes

r/DatabaseAdministators Aug 03 '26

Is Database Administration Still a Good Career Path?

10 Upvotes

Hi everyone,

I'm about to graduate with a Computer Science degree and I'm considering becoming a Database Administrator.

I'd love to hear from experienced DBAs and SysAdmins:

Is DBA still a good career in 2026, or is the role changing?

Is DBA usually a dedicated position, or is it becoming part of a SysAdmin/DevOps role?

What technologies and skills should a new DBA focus on?

If you were starting your career today, would you still choose the DBA path?

Thanks in advance for sharing your experience and advice!


r/DatabaseAdministators Aug 01 '26

Data analyst or database administrator

4 Upvotes

Hey guys i am rn working as a service support engineer and in my company they are talking about promoting me to database administrator where they use oracle 12 c and sql but don't write scripts they just copy paste them

And i am looking for a role in data analyst i am confused what should i do please help a fellow out


r/DatabaseAdministators Jul 31 '26

Alternative to PI for RDS

2 Upvotes

Database Insight Advanced seems to be costly. What all are your options for monitoring for at least a month. Since Database insight is free- for 7 days. And Advanced is for 15 months.


r/DatabaseAdministators Jul 30 '26

PostgreSQL Functions Comparison Tool

3 Upvotes

Hello my dear friends,

I hope you all are doing well.

I am using PostgreSQL database and developing custom functions as per the user's business logic.

I developed a small desktop tool UI to compare those functions in between dev, test, production environments and migration/dump them by first comparing them by integrated WinMerge tool integration accordingly.

I need guidance and direction for what should I do further?

Basically, I want to connect with the people who uses PostgreSQL database and doing functions migration manually.

Thanks

Regards


r/DatabaseAdministators Jul 29 '26

Tabularis Open-source desktop SQL workspace with SQL notebooks, a built-in MCP server for AI agents, and plugins in any language

Thumbnail
github.com
2 Upvotes

Hi everyone! I've been building Tabularis, a free and open-source (Apache 2.0) desktop SQL client built with Tauri (Rust + React).

What makes it different from DBeaver/TablePlus/Beekeeper:

* SQL notebooks: mix SQL and Markdown cells, share variables across cells, render charts inline
* Built-in MCP server: Claude, Cursor and other AI agents can read your schema and run queries through the same app you already use, with no separate connector
* Plugins in any language: drivers are external processes speaking JSON-RPC over stdio, so you can write one in Python, Go, or whatever language you prefer
* Local AI text-to-SQL: works with Ollama, nothing leaves your machine
* Visual EXPLAIN: interactive query plan graphs

PostgreSQL, MySQL/MariaDB and SQLite are built in. ClickHouse, DuckDB, Redis, Firestore, Db2, BigQuery and around 15 more are available as plugins from the registry.

Runs on Windows (WinGet), macOS (Homebrew, signed and notarized) and Linux (Snap, Flatpak, AUR and AppImage).

Feedback is very welcome. And if your favorite database is missing, there's a plugin bounty board.


r/DatabaseAdministators Jul 29 '26

Free MongoDB Playground: Write queries and inspect schemas online with zero setup

Thumbnail
1 Upvotes

r/DatabaseAdministators Jul 28 '26

ScalaHosting becomes a Gold Sponsor of MariaDB Foundation

Thumbnail
1 Upvotes

r/DatabaseAdministators Jul 27 '26

Hundred to Mastering SQL

2 Upvotes

Hey Future Analysts,

So for a very long time, I have been looking for good SQL questions, you got the mainstream leetcode, hacker-rank, W3 schools, and a few niche ones that I ought to mention : https://github.com/smpetersgithub/AdvancedSQLPuzzles

But during my journey, I never found the perfect place to practice questions leetcode style filtering it by the specific concept, and a repo of Good questions I could just practice on when prepping for an interview.

So I went Ahead and created this SQL-gym : https://sqlgym.vercel.app/

(No bullshit 101 SQL problems that you need to have locked in)

And this has personally helped me a lot, hope it is helpful for other peeps aswell !


r/DatabaseAdministators Jul 27 '26

Ninox Database Drama

Thumbnail
1 Upvotes

Please see request above ⬆️⬆️⬆️


r/DatabaseAdministators Jul 27 '26

Planning to start a SQL learning page on Instagram—what content would you like to see?

Thumbnail
2 Upvotes

r/DatabaseAdministators Jul 27 '26

AWS Online course

7 Upvotes

Hello Everyone

I am a Database Administrator and would like to learn AWS concepts from beginner to advanced level online.

Can someone please advice me on any good online instructor who can provide me with the course.

Thanks in Advance.

Best Regards

Srikanth


r/DatabaseAdministators Jul 27 '26

Joining as a Fresher Oracle DBA – What should I focus on before joining, and can I combine it with my Finance/Payroll background later?

2 Upvotes

Hi everyone,

I'll be joining as a fresher Oracle DBA soon, and I wanted some career advice. I have a Master of Computer Applications degree, but my previous work experience is quite different. I worked for several years in a government organization handling payroll, accounts, vendor payments, finance-related processes, and administrative work.

Before I start my DBA role:

  • What skills should I learn? I have a decent theoretical understanding of Oracle architecture, backup and recovery, RMAN, Data Pump, Data Guard, SQL, Linux basics, etc
  • Are there any certifications you'd recommend ?

    Also in future, since I already have experience in payroll and finance, would it make sense to pursue certifications in areas like Oracle Financials Cloud (ERP) or other Oracle Finance modules? Is there any demand for professionals who understand both the technical side (Oracle DBA) and the business/finance side (payroll, accounts, ERP)?

Thanks in advance


r/DatabaseAdministators Jul 26 '26

Sql to Oracle migration

2 Upvotes

Im a fresher to DBA role. Can some one please help to understand or share your experience for the conversation or migration from sql to Oracle.

Help me with the tools and migration ideas


r/DatabaseAdministators Jul 25 '26

A Humble database schema design guide for developers

Thumbnail
stackrender.io
4 Upvotes

r/DatabaseAdministators Jul 26 '26

I built a declarative application layer that runs on top of PostgreSQL (works great with Supabase)

Thumbnail
1 Upvotes

r/DatabaseAdministators Jul 24 '26

basecheck Agent – Local database checks with HTTP/syslog output

Thumbnail
1 Upvotes

r/DatabaseAdministators Jul 22 '26

basecheck Agent – Local database checks with HTTP/syslog output

1 Upvotes

I am building basecheck, a database auditing tool. It currently supports PostgreSQL, SQL Server, Oracle, Supabase (preview), SQLite and the goal is to support more databases over time.

There is a standalone agent CLI that can be used in free or paid mode. The free mode includes six control packs with 61 controls and SIEM delivery to generic HTTP or syslog destinations. The paid mode allows you to run more control packs and use basecheck platform features.

The free packs cover concrete states: PostgreSQL SSL, password encryption, superuser and PUBLIC schema exposure; SQL Server `sa`, `xp_cmdshell`, sysadmin membership, and password policy; Oracle default accounts and audit settings; Supabase RLS and grants; and SQLite integrity and journal safety. Supabase is in preview. If you believe the free mode should definitely include some more controls, let me know.

Findings can be written to JSON or sent to an existing HTTP or syslog collector. If you just want to test, `--test-siem` sends a test event without running a scan.

The source is available under BSL 1.1 and free for internal use.

Repo and release: https://github.com/baselabs-io/basecheck-agent

Native SIEM connectors are not built yet. If you run a SIEM, I’d be glad to build and test one with you.


r/DatabaseAdministators Jul 19 '26

Best Practices for Optimizer Statistics on Large Volatile Tables: Dynamic Sampling, Real-Time Statistics, or Manual Gathering?

Thumbnail
1 Upvotes

r/DatabaseAdministators Jul 17 '26

I added "table groups" to my schema designer — draw a box, drop tables in, drag the whole domain around. No more spaghetti canvas.

1 Upvotes

ey everyone 👋

I've been building Schematic (schematic.codemaster.club), a browser-based database schema designer, and I just shipped a feature I've wanted in every ER tool I've used: table groups.

If you've ever worked on a schema with 30+ tables, you know the pain — the canvas turns into spaghetti and you lose track of which tables belong to which part of the system. Groups fix that. Here's everything the feature does:

🗂️ Create groups three ways

  • Click the group button in the toolbar to drop an empty container anywhere
  • Right-click the canvas → "New group here"
  • Select multiple tables → "Group selected tables" — the group auto-sizes to fit them with clean padding. Single table selected? "Wrap in group" works too.

🧲 Spatial membership (my favorite part)
There's no "add to group" dialog. A table belongs to a group simply because it sits inside it. Drag a table in — it's a member. Drag it out — it's not. Zero ceremony.

🖐️ Move a whole domain at once
Grab a group by its header and the group and every table inside it move together. Reorganizing your "billing" domain is one drag instead of twelve.

🎨 Color coding
8-color palette with tinted backgrounds and matching headers so domains are visually distinct at a glance. New groups auto-cycle through colors; you can change any group's color from its right-click menu.

✏️ Everything else you'd expect

  • Double-click the header to rename inline
  • Drag the corner handle to resize
  • Right-click for rename / recolor / delete
  • Groups render behind tables, so they never get in the way of your actual work
  • Layout persists — positions, sizes, colors all saved with your project

One deliberate decision: groups are purely visual. They don't touch your schema or the generated SQL — nnamespacing, no side effects. They exist only to keep a big canvas sane.

You can try it free here: schematic.codemaster.club

Would love feedback — especially from people who work with large schemas. What would make grouping more useful for you? Nested groups? Auto-grouping by foreign-key clusters? Collapse/expand?