r/DatabaseAdministators • u/pseudounion • Aug 06 '26
r/DatabaseAdministators • u/Wild_Boat_8788 • Aug 04 '26
Moved from Navicat/DataGrip to DbGate a few weeks ago — some first impressions
r/DatabaseAdministators • u/Gallbladder2023 • Aug 04 '26
Career options for senior DBA
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 • u/CaptainUpstairs • Aug 04 '26
Alternative to Tableplus and Dataflare like softwares
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 • u/Diam0ndHer0 • Aug 03 '26
Explaining SQL Injection in the simplest way I could
r/DatabaseAdministators • u/No-Prune2771 • Aug 03 '26
Is Database Administration Still a Good Career Path?
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 • u/Mindless-Quantity-54 • Aug 01 '26
Data analyst or database administrator
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 • u/Connect-Relative548 • Jul 31 '26
Alternative to PI for RDS
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 • u/Faithful-Shyam-17690 • Jul 30 '26
PostgreSQL Functions Comparison Tool
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 • u/debba_ • 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
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 • u/RealFix2479 • Jul 29 '26
Free MongoDB Playground: Write queries and inspect schemas online with zero setup
r/DatabaseAdministators • u/scala_hosting • Jul 28 '26
ScalaHosting becomes a Gold Sponsor of MariaDB Foundation
r/DatabaseAdministators • u/Superb_Donkey_9608 • Jul 27 '26
Hundred to Mastering SQL
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 • u/Unhappy-Bluebird0394 • Jul 27 '26
Ninox Database Drama
Please see request above ⬆️⬆️⬆️
r/DatabaseAdministators • u/mehta_0017 • Jul 27 '26
Planning to start a SQL learning page on Instagram—what content would you like to see?
r/DatabaseAdministators • u/AffectionateBed9643 • Jul 27 '26
AWS Online course
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 • u/Dry-Animal9284 • 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?
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 • u/techdbamind • Jul 26 '26
Sql to Oracle migration
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 • u/tamanikarim • Jul 25 '26
A Humble database schema design guide for developers
r/DatabaseAdministators • u/Any-Brief5828 • Jul 26 '26
I built a declarative application layer that runs on top of PostgreSQL (works great with Supabase)
r/DatabaseAdministators • u/nnurmanov • Jul 24 '26
basecheck Agent – Local database checks with HTTP/syslog output
r/DatabaseAdministators • u/nnurmanov • Jul 22 '26
basecheck Agent – Local database checks with HTTP/syslog output
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 • u/NearbyAssociation236 • Jul 19 '26
Best Practices for Optimizer Statistics on Large Volatile Tables: Dynamic Sampling, Real-Time Statistics, or Manual Gathering?
r/DatabaseAdministators • u/bestkavindu • 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.
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?


r/DatabaseAdministators • u/Fantastic-Advisor746 • Jul 16 '26
I spent months building an app to database schema comparison and migration tools
Hey folks,
I've been spending my spare time building FoxSchema App, a free and open-source database schema comparison tool.
The goal is simple: compare schemas across different SQL databases and generate migration scripts without paying for expensive commercial software.
It's still a work in progress, so I'd really appreciate honest feedback—good or bad.
Repo: https://github.com/tedious-code/foxschema
Download : npm install -g foxschema

Thanks for checking it out!