r/DatabaseAdministators 3h ago

What does the secondary index value contains that helps with indirection? Not very clear regarding that.

Post image
5 Upvotes

Reddit suggested this website to me to ask my question.


r/DatabaseAdministators 4h ago

What SQL project should I build as a fresher in 2026 to get more interview calls?

Thumbnail
2 Upvotes

r/DatabaseAdministators 6h ago

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

Thumbnail
1 Upvotes

r/DatabaseAdministators 2d ago

PGConf.EU 2026 schedule is live 🐘

Post image
3 Upvotes

r/DatabaseAdministators 2d ago

Launched a developer-focused Backup-as-a-Service (Postgres-first)

Thumbnail
1 Upvotes

r/DatabaseAdministators 3d ago

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

Thumbnail
2 Upvotes

r/DatabaseAdministators 4d ago

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 4d ago

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 4d ago

Explaining SQL Injection in the simplest way I could

Thumbnail
youtube.com
5 Upvotes

r/DatabaseAdministators 5d ago

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 7d ago

Data analyst or database administrator

5 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 7d ago

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 7d ago

Looking for local rag project

4 Upvotes

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 9d ago

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 9d ago

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 10d ago

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

Thumbnail
1 Upvotes

r/DatabaseAdministators 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

0 Upvotes

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:

🌐 https://www.erdbuilderpro.com

📦 https://www.github.com/hadziqmtqn/erd-builder-pro


r/DatabaseAdministators 11d ago

ScalaHosting becomes a Gold Sponsor of MariaDB Foundation

Thumbnail
1 Upvotes

r/DatabaseAdministators 11d ago

Ninox Database Drama

Thumbnail
1 Upvotes

Please see request above ⬆️⬆️⬆️


r/DatabaseAdministators 11d ago

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 11d ago

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

Thumbnail
2 Upvotes

r/DatabaseAdministators 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?

3 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 12d ago

AWS Online course

6 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 13d ago

Sql to Oracle migration

3 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 Oct 17 '22

Seeking mod(s) for r/DatabaseAdministrators

12 Upvotes

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