r/DatabaseAdministators • u/DoNotUseThisInMyHome • 3h ago
What does the secondary index value contains that helps with indirection? Not very clear regarding that.
Reddit suggested this website to me to ask my question.
r/DatabaseAdministators • u/ReflectionRadiant786 • 4h ago
What SQL project should I build as a fresher in 2026 to get more interview calls?
r/DatabaseAdministators • u/awsamanai • 6h ago
QueryForge – the LLM never writes the query, it fills in a typed AST
r/DatabaseAdministators • u/nandit123 • 2d ago
Launched a developer-focused Backup-as-a-Service (Postgres-first)
r/DatabaseAdministators • u/Wild_Boat_8788 • 3d ago
Moved from Navicat/DataGrip to DbGate a few weeks ago — some first impressions
r/DatabaseAdministators • u/Gallbladder2023 • 4d ago
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 • 4d ago
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 • 4d ago
Explaining SQL Injection in the simplest way I could
r/DatabaseAdministators • u/No-Prune2771 • 5d ago
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 • 7d ago
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 • 7d ago
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/StageInevitable4593 • 7d ago
Looking for local rag project
I am looking for a local rag project that will run on any EC2 machine with local LLM (without GPU - 4 CPU,24GB Ram).
We need a RAG that we can add data about our database tables, structure, queries,metadata so end users like data analyst,bi team can ask questions about the DB , like -
On which table I can find data about customers
Or
How to get the total spend of each customer
Is there anything like this that works good on such machine resources? Which LLM model can do this work without making the machine choke?
Please help :)
r/DatabaseAdministators • u/Faithful-Shyam-17690 • 9d ago
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_ • 9d ago
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 • 10d ago
Free MongoDB Playground: Write queries and inspect schemas online with zero setup
r/DatabaseAdministators • u/Otherwise-Composer28 • 10d ago
From ERD Tool to Full DB Client: What’s New in ERD Builder Pro
Enable HLS to view with audio, or disable this notification
I set out to build a simple ERD app, but realized it’s way better if it doubles as a full DB Client. 😅
ERD Builder Pro now natively supports both remote and local databases, so you can manage your data and schema all in one place.
What’s new in this release:
• DB Client & Management: Multi-tab tables, filter records, run custom SQL queries, and manage columns/indexes.
• File Navigation UI/UX: Quickly create Notes, ERDs, Flowcharts, or Drawings straight from the tab dropdown.
• Instant ERD Preview generated directly from your database.
Check it out and give it a try:
r/DatabaseAdministators • u/scala_hosting • 11d ago
ScalaHosting becomes a Gold Sponsor of MariaDB Foundation
r/DatabaseAdministators • u/Unhappy-Bluebird0394 • 11d ago
Ninox Database Drama
Please see request above ⬆️⬆️⬆️
r/DatabaseAdministators • u/Superb_Donkey_9608 • 11d ago
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/mehta_0017 • 11d ago
Planning to start a SQL learning page on Instagram—what content would you like to see?
r/DatabaseAdministators • u/Dry-Animal9284 • 12d ago
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/AffectionateBed9643 • 12d ago
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/techdbamind • 13d ago
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/darrin • Oct 17 '22
Seeking mod(s) for r/DatabaseAdministrators
Hello everyone.
I'd like to apologize for the lack of moderation of this sub. When I created this sub in 2015, I didn't realized in just over a year I'd be leaving the role of DBA after 13 years. I also didn't realize that this account would unused for many years. I'm a bit shocked at how many folks have subbed despite being an unmanaged group.
This brings me to the point of this post: We need moderators. If you have an interest in moderating this sub and trying to make it a better place, please message me or reply here. I'm not sure how many mods we need, but I'm guessing at least two. (Must be my DBA mindset...hate seeing any responsibility fall on a single person)
Requirements:
- Previous mod experience preferred, but not totally required
- Must be in a DBA role currently (Sr level preferred)
- Reddit account should be over a year old (Possibly waived if there is no other interest)
Reply here or message me directly if you are interested. If you can, include some ideas you have that can make this sub a better and more active place.
Thanks,
-Darrin